How to Create SAP Sybase Roles and Handle Permission & Cleanup

In this video, I talk about how to create login, associate user with that, create role, assign object access to the role and verification.
Post all creation, how to do clean-up i.e. when you need to revoke the permission, drop the role and user as well as login.
Access Permission Video - • Tutorial on SAP Sybase...
#SAPSybaseInterviewQuestions
#SAPSybaseASEInterviewQuestions
#SAPSybaseDatabaseTutorial

[@narendraaakula8895]

thanks for your valuable information and time, pls try to share more information on sybase

[@dbasdiary]

Thank you for your comment, will definitely do.

[@ravijaiswal6727]

Thank you Sir , I've one question Can we assign role to database user . if yes how can we write SQL query to to list which database user has what role ?

[@dbasdiary]

First thing is login, which is defined at server level, roles are also defined at server level. User is defined at database level, you need to add login as a user in any database and then grant role. Granting permission to a login and role is very similar, as far as finding permission is concerned, you can get details using sp_helprotect. Sorry for late response.