Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
Permissions
Search for
any
content tagged
permissions
Add a script
Items 1 to 12 of 12
Reverse-Engineer Database Permissions (2005 up)
This script reverse engineers SQL statements to recreate database permissions.
Read more...
By
george sibbald
2011/10/24
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
2,140 reads
Retrieve Database Object permission scripts and Role members scripts
I often need to synchronize the user permission between databases. I wrote this simple query to script the sql statement to per item.
Read more...
By
Gokhan Varol
2011/02/03
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
2,301 reads
Stored procedure to script out user permissions
Stored procedure to script out user permissions
Read more...
By
Harsha Majety
2011/01/17
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
3,809 reads
Script DB Level Permissions v2.1
Scripts role membership, object-level permissions for all DB users.
Read more...
By
S. Kusen
2011/02/02
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,947 reads
The Complete SQL Server 2005 Permissions Report
The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.
Read more...
By
Richard Lu
2010/05/10
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
6,025 reads
Grant Mass permissions
Create A role and grant it a permission on a DB Schemas.
Read more...
By
mobasha B
2009/04/09
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
1,112 reads
Determine Users with Permission on an Object
This script will walk the hierarchical chain of users and roles to find users with permissions on an object.
Read more...
By
Charles Hawkins
2009/03/24
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
1,432 reads
Change Ownership of a Maintenance Plan
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
Read more...
By
Phill Carter
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
ownership
Rating:
|
Discuss
|
Briefcase
|
2,745 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
10,800 reads
Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
Read more...
By
Mani Singh
2008/08/01
|
Source:
SQLServerCentral.com
|
Category:
administrator
Rating:
|
Discuss
|
Briefcase
|
2,393 reads
Column Level Permissions
GRANT Column Level Permissions
Read more...
By
Mani Singh
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,507 reads
Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
Read more...
By
stumbling fish
2011/12/12
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
3,674 reads
Items 1 to 12 of 12
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.