PC Review


Reply
Thread Tools Rate Thread

The definition of access rights in MS SQL Server 2005

 
 
Alexander Vasilevsky
Guest
Posts: n/a
 
      21st Jan 2008
How programmic (C#) to know whether there is a right of access to the server
object (table, stored procedure) for current user.

http://www.alvas.net - Audio tools for C# and VB.Net developers


 
Reply With Quote
 
 
 
 
Jesús López
Guest
Posts: n/a
 
      21st Jan 2008
Execute a query like the following:

select distinct permission_name from fn_my_permissions('your table or stored
procedure name', 'OBJECT')

where subentity_name = '' or subentity_name is null



"Alexander Vasilevsky" <(E-Mail Removed)> escribió en el mensaje
news:fn2n7g$2690$(E-Mail Removed)...
> How programmic (C#) to know whether there is a right of access to the
> server object (table, stored procedure) for current user.
>
> http://www.alvas.net - Audio tools for C# and VB.Net developers
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
server access rights to backend mdb tsluu Microsoft Access 1 19th Feb 2010 08:40 AM
Remote Access Server Definition refinement PPNP related goal. =?Utf-8?B?SiBIaWdzb24=?= Windows XP Work Remotely 0 15th Sep 2006 05:13 PM
Send Form Definition Alternative - No OFL Rights Boyd Microsoft Outlook Form Programming 1 20th Jan 2006 05:23 PM
Access database on Server 2003 (rights issue) Jay Microsoft Access 3 23rd Dec 2004 05:43 PM
Windows 2000 Server Access Rights rgwhite Microsoft Windows 2000 Security 2 1st Nov 2003 12:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:06 PM.