any body has a script to script users permissions on db objects 
Author Message
 any body has a script to script users permissions on db objects
any body has a script to script users permissions on db objects


Tue, 06 Jan 2004 02:37:11 GMT
 any body has a script to script users permissions on db objects

Akshay,

are you referring to object-level permissions?

You can do that under security options in the options tab of the Generate
sql scripts window in sql enterp.manager...

Dinesh.



Tue, 06 Jan 2004 03:45:21 GMT
 any body has a script to script users permissions on db objects
i was looking at some alternate solution

Quote:
> Akshay,

> are you referring to object-level permissions?

> You can do that under security options in the options tab of the Generate
> sql scripts window in sql enterp.manager...

> Dinesh.



Tue, 06 Jan 2004 04:05:21 GMT
 any body has a script to script users permissions on db objects
Take a look at the INFORMATION_SCHEMA.TABLE_PRIVILEGES view and the
PERMISSIONS system function.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.


Quote:
> i was looking at some alternate solution


> > Akshay,

> > are you referring to object-level permissions?

> > You can do that under security options in the options tab of the
Generate
> > sql scripts window in sql enterp.manager...

> > Dinesh.



Tue, 06 Jan 2004 15:51:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. script object-level permissions

2. Scripting Object Permissions

3. Scripting Role Permissions and Users

4. Users/Logins/Permissions Script

5. converting paradox dos script to paradox (object pal) windows script

6. How do you script all object of a database to a script file

7. Need SQL Script to reverse-engineer datbase users, groups, permissions for SQL 6.5

8. Question for Script of users permission.

9. Script Newbi - how to you ask user in a script

10. How can I script db from tsql script?

11. Createing several users with objects from script

12. Scripting DB Objects using TSQL


 
Powered by phpBB® Forum Software