Thanks Greg.But DBA who is having Sysadmin role will have the Security Priviliges like GRANT,REVOKE & DENY also.So our company wants to separte the tasks. Is it possible to have...

Hi ,

Thanks.I got it.

Ihave another doubt.Is segregation of duties possible in sql2000/sql 2005.

like all dba tasks separate and security admin tasks separate.

Kindly provide me answer for this.

Thanks in advance

MAnjula

Thanks for the reply.

But if I grant db_acessadmin and db_securityadmin roles ,user will get incorporated other permissions also.Hence I want the user has the privilege to execute sp_adduser only.

Regards

MAnjula

Thanks so much for your information

Hi,

All databases

Thanks

MAnjula

Hi,

Yes.i need the roles and permissions(on which objects).

Pls correct me if iam wrong.

Thanks,

MAnjula

Hi Elisabeth,

My requirement is "I want to display the users who have permissions of all roles inclusive server roles or database or userdefined roles."

Thanks & Regards,

MAnjula.

Hi Elisabeth,

Thanks so much.

Iam newbie.

Can you tell me for displaying permissions(both user defined and predefined ) any procedure like sp_helpuser in query analyzer?

Regards,

MAnjula