The definition of access rights in MS SQL Server 2005

[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

 

[Jesús López]

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