Buy Questpond's video subscriptions on
huge discount
.
Online: 1090
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
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
< Previous :
How we can deploy SSIS?
Next > :
Which property need in the email functionality to ...
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
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 ...
Which methods are used to execute javascript code from code behind fil ...
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 ?
More ...