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

  • 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: [OT, welcome msg] Retrieve printer permissions programmatically
    ... > How do you retrieve a shared printer's permissions ... > programmatically?Theprinter is a network printer.NetShareGetInfo seems ... > solution for 9x as well as NT systems using the Windows SDK API? ...
    (comp.lang.cpp)
  • Getting Group information from folder
    ... Is there a way to loop through the entire root of a drive and retrieve all ... groups and users that have permissions on the folder and what permissions ...
    (microsoft.public.vb.enterprise)