Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1090
Home > Interviews > Sql Server >

How we can check the database permission for any user?

 Posted by Lakhangarg on 2/26/2010 | Category: Sql Server Interview questions | Views: 4721
Post | Interview FAQs | Exclusive Questions | Interview Home  
Answer:

SELECT * FROM fn_my_permissions (null, 'DATABASE');


Asked In: Many Interviews | Alert Moderator 

Bookmark It

Comments or Responses

Posted by: Puneet20884 on: 2/26/2010
Not returning any record, what will be the possible cause and can you please justify the significance of various arguments that this function is taking ??
Posted by: Lakhangarg on: 2/26/2010
This will return the result for the login user.


Posted by: Raja on: 2/26/2010
It's really not returning anything. Lakhan, can you please elaborate it in detail. I am logged into SQL Server Management Studio and executed the code and it returns nothing to me.
Posted by: Lakhangarg on: 2/26/2010
Hi-
Steps to check-
(1) Login to Databse server.
(2) Open the query window
(3) Select the Database
(4) Execute the above query

Please check the detail from here...
http://msdn.microsoft.com/en-us/library/ms176097.aspx

Login to post response

More Interview Questions by Lakhangarg


Latest Interview Questions