Re: DB Access for SQL server

OA

IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
PRINT 'INSERT on authors is grantable.'
ELSE
PRINT 'You may not GRANT INSERT permissions on authors.'

------http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pa-pz_6f78.asp>
How can I retrieve a list of objects and permissions for a specified role?


"OA" <omrana@xxxxxxxxxxx> wrote in message
news:eGXSXnkpIHA.4736@xxxxxxxxxxxxxxxxxxxxxxx
How could I find a list of who has write access within my SQL2K5.



Thanks



.

Relevant Pages

  • Re: Roles and permission mapping table
    ... How can I retrieve a list of objects and permissions for a specified role? ... In SQL Server 2005, you can use the Has_Perms_By_Namefunction ...
    (microsoft.public.sqlserver.security)
  • SQL Server role permissions
    ... How can I retrieve a list of objects and permissions for a specified role? ... I would like to list all stored procedures which a role has ...
    (microsoft.public.sqlserver.security)
  • Walking the file system
    ... files and folders during an overnight process. ... and reset all permissions back to what they should be. ... I know that I can do this with DirectoryInfo objects, ... Is there a system call that can retrieve a list of files ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Object Permissions query
    ... So you may need to write a query based on both the above tables. ... > I am wanting to construct a query to retrieve a list of tables and views ... group-level permissions, such as ddl_admin, etc. ... retrieve a list of views and tables that User "A" or it's parent group ...
    (microsoft.public.sqlserver.programming)
  • Re: Roles and permission mapping table
    ... How can I retrieve a list of objects and permissions for a specified role? ... In SQL Server 2005, you can use the Has_Perms_By_Namefunction ...
    (microsoft.public.sqlserver.security)