How to grant the roles to sybase logins

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