In this article, we are going to get list of permissions granted to the user on a table in Sybase. We can get permissions on a table to user by using the stored procedure sp_helprotect.
Syntax:
sp_helprotect table_name, user_name
1. Get the list of all permissions granted on a table.
sp_helprotect emp go
Output:
2. Get list of permissions granted to user on a table.
sp_helprotect emp,kiran go
Output: