Simple Cursor to look for User objects and grant access to a user or group: DROP PROCEDURE VANTIVE_GRANT_DB_OBJECT_RIGHTS GO CREATE PROCEDURE VANTIVE_GRANT_DB_OBJECT_RIGHTS --GRANTS SPECIFIC RIGHTS TO SPECIFIC DB USERS @DBUSERNAME VARCHAR(25) = 'DBUSER', @RIGHTS VARCHAR(8) = 'ALL' --Select, execute, AS DECLARE Rights_Cursor Cursor FOR SELECT 'GRANT '+ @RIGHTS +' ON '+ NAME +' TO '+ @DBUSERNAME FROM SYSOBJECTS WHERE TYPE IN ('U','P', 'V') ---User Tables, Proceedures and Views OPEN Rights_Cursor DECLARE @SQLSTR VARCHAR(120) FETCH NEXT FROM Rights_Cursor Into @SQLSTR WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN PRINT @SQLSTR EXEC (@SQLSTR) END FETCH NEXT FROM Rights_Cursor Into @SQLSTR END CLOSE Rights_Cursor DEALLOCATE Rights_Cursor GO ---EXEC VANTIVE_GRANT_DB_OBJECT_RIGHTS OR DECLARE Rights_Cursor Cursor FOR Select name from sysobjects WHERE type in ('u','p', 'v') Open Rights_Cursor DECLARE @NAME VARCHAR(50) Fetch Next FROM Rights_Cursor Into @NAME WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN Grant ALL ON @name to DBUser1 END Fetch Next FROM Rights_Cursor Into @NAME END CLOSE Rights_Cursor DEALLOCATE Rights_Cursor GO