Many of the commands and procedures require the system administrator or system security officer role
we can grant the roles to sybase logins in 2
ways
Method 1:
sp_role stored procedure is used
to grant the roles to sybase logins
login with system administrator
and check the below command
sp_displaylogin
<login_name>
Displays information about a login account
the above figure shows login doesn’t have any roles
to check the login authorizations, use the below command
Method 2:
grant role command is used to grant the roles to sybase logins.
to check the login authorizations use the below command
