The definition of access rights in MS SQL Server 2005

  • Thread starter Thread starter Alexander Vasilevsky
  • Start date Start date
A

Alexander Vasilevsky

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
 
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
 
Back
Top