Restrict Users To Seeing Just "their" Rows on a Select description
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 session user ID. SQL with narrative.
File List:
restrict_users_to_seeing_just_their_rows.sql
6Kb
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” ... 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. dbasp_GlobalGrant
(Popularity: ) : 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.
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” ...