| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Batch Change Object Owner | SQL Server 7.0 | Advanced /
Lewis E. Moten III | 12599 since
2/14/2002 10:50:47 PM |
By 1 Users
|
| |
demonstrates how to use a cursor to change all db objects to DBO as the owner. |
| |
| |
| |
|
 dbasp_GlobalGrant | SQL Server 2000, SQL Server 7.0 | Intermediate /
Brent Glover | 9538 since
4/30/2001 12:27:32 AM |
By 3 Users
2 Excellent Ratings
|
| |
This is a piece of code I use to globally grant or revoke permissions on all or set of objects in a Database for a given valid user. |
| |
| |
| |
|
Decrypt MS SQL 2000 stored procedures of ANY SIZE! | SQL Server 2000 | Advanced /
Alexander Polozov | 17546 since
11/5/2002 3:03:54 AM |
By 10 Users
10 Excellent Ratings
|
| |
This MS Access application will decrypt Stored Procedures encrypted using "with encryption" option.
If automatic removing of "with encryption" option fails user will asked to manually modify the source of SP. The source of SP must start with “ALTER PROCED ...(description truncated) (ScreenShot) |
| |
| |
| |
|
DECRYPT SQL SERVER 2000 STORED PROCEDURES, VIEWS AND TRIGGERS (WITH EXAMPLES) | SQL Server 2000 | Advanced /
Joseph Gama | 337476 since
7/9/2002 6:26:39 AM |
By 31 Users
25 Excellent Ratings
|
| |
This SP will decrypt Stored Procedures, Views or Triggers that were encrypted using "with encryption"
There are 2 versions: one for SP's only and the other one for SP's, triggers and views
version 1:
INPUT: object name (stored procedure, view or trigger)
...(description truncated)(ScreenShot) |
| |
| |
| |
|
Decrypt/Display Large SQL 2000 Stored Procedures v1.00.1 | SQL Server 2000 | Advanced /
Jonathan Spinks | 15073 since
7/24/2003 12:11:55 PM |
By 8 Users
6 Excellent Ratings
|
| |
This stored procedure will allow you to display or decrypt very long encrypted stored procedures (40,000 chars). This sp will also keep / display any permissions associated with it.
The original concept for this code came from Joseph Gama (Nice work! Coul ...(description truncated) |
| |
| |
| |
 |
Encryption Utilities | SQL Server 2000 | Advanced /
Brad G Skidmore | 5276 since
9/25/2007 7:35:18 AM | Unrated
|
| |
Utility to Encrypt and Salt Hash sensitive passwords. |
| |
| |
| |
|
End-to-End Hash Logon | SQL Server 2000 | Intermediate /
James A Hough | 11913 since
8/2/2003 3:40:27 PM | Unrated
|
| |
This code is is a sample application demonstrating an End-to-End has logon process where the user's password is hashed using MD5 and compared to the stored MD5 hash of the password in the SQL database. The Hash is protected while travelling over the netwo ...(description truncated) |
| |
| |
| |
|
grant permissions on tables to users of your choice | Oracle | Beginner /
John Hunsley | 11733 since
2/25/2003 1:54:16 PM |
By 1 Users
|
| |
this code uses sql from sql to run lots of commands.
the sql spools the required commands from the user_constraints ans user_tables data dictionary, it then prompts the user to input the user name of the person you want to grant permissions to, then runs ...(description truncated) |
| |
| |
| |
|
Grant Public Execute Rites | SQL Server 7.0 | Advanced /
Lewis E. Moten III | 9891 since
2/14/2002 10:52:16 PM |
By 2 Users
|
| |
Grants execute rites on all stored procedures to the public. can be modified to grant to other users. |
| |
| |
| |
|
GrantUserExecuteAll | SQL Server 2000 | Beginner /
Lewis E. Moten III | 9121 since
11/8/2002 1:10:38 PM |
By 1 Users
|
| |
Allows you to specify a username and grant access to execute all SQL stored procedures within the current database. Very useful for developers that create databases with one account, but have programs accessing them through a seperate user account. This i ...(description truncated) |
| |
(ScreenShot)
(ScreenShot)
