Login Permissions

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  January 16, 2009 at 1:20 am

  #94632

  Hi All,

  Can you please help me in finding out the permissions or previlagaes of a Login.

  Means what is the server roles that login is having, or to which database that is having the access and what permissinos it is having etc... using T-SQL

  Thanks advance

  Thank You.

  Regards,
  Raghavender Chavva

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 16, 2009 at 1:52 am

  #927887

  Duplicate of:

  http://www.sqlservercentral.com/Forums/Topic637789-359-1.aspx

  Reply on the above link..

  -Vikas Bindra

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  January 17, 2009 at 10:43 am

  #928705

  Looks Like the URL Provided is for SQL Server 2005, and I want the same in SQL Server 2000 also. For that reason only I have added another topic in SQL Server 2000 part.

  Thank You.

  Thank You.

  Regards,
  Raghavender Chavva

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  January 17, 2009 at 10:45 am

  #928706

  Hi all,

  Thanks for your help, I got my answer.

  Thank You.

  Regards,
  Raghavender Chavva