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.
File List:
@PSC_ReadMe_297_5.txt
1Kb
dbasp_GlobalGrant.sql
4Kb
dbasp_GlobalRevoke.sql
4Kb
Similar code
Decrypt MS SQL 2000 stored procedures of ANY SIZE!
(Popularity: ) : 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 PROCEDURE” ... Restrict Users To Seeing Just "their" Rows on a Select
(Popularity: ) : As long as user ID is carried in one of the columns, you can easily restrict a Select from a table to user-specific rows by creating a VIEW of the table that only returns rows where the user ID matches ... SQLCrypto And XLSure Encryption Utilities
(Popularity: ) : SQLCrypto Base Encryption + Hash ZIP files include the SQLCrypto Install, as well as Demo Scripts that install a sample database and all the encryption utilities you would need to start securing your sensitive passwords.
Code Library
) : 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 PROCEDURE” ...