Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How we can check the database permission for any user?
on 2/26/2010 | Category:
Sql Server Interview questions
| Views: 3797
SELECT * FROM fn_my_permissions (null, 'DATABASE');
Many Interviews |
< Previous :
How we can deploy SSIS?
Next > :
Which property need in the email functionality to ...
Comments or Responses
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 ??
This will return the result for the login user.
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.
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...
Login to post response
More Interview Questions by Lakhangarg
Which property need in the email functionality to set to send the cont ...
What is the Namespace of ForAuthentication class?
Which Editor we can use to create the SSIS Packages?
How we can gt the values of control on the previous page in case od se ...
Can we use Page.PreviousPage to get the value of controls of the previ ...
What is the page size in SQL Server?
What is the main difference between RegisterStartUpScript and Register ...
Latest Interview Questions
Name the table where the Index information is saved
What is the page size of Index Page ?
What is the use of APP_NAME()?
What is the use of CHAR function?
Which function is used to know the database property in SQL Server.
How can we check the locks defined in a DB ?
What are the variuos lock types ?
What are the various transaction isolation levels ?