... SELECT statements. SET NOCOUNT ON; Print N'Set Role Permissions'; EXEC sys.sp_addrolemember @rolename=N'sql_dependency_subscriber', @membername=N'Role'; -- ============================================= -- SCHEMA Restrictions -- ...[UA].[F_SP] TO [Role]; -- Defined for each stored procedure need by Role. EXEC sys.sp_helprotect @Rolename=N'Role' END

... statements. SET NOCOUNT ON; Print N'Set Role Permissions'; EXEC sys.sp_addrolemember @rolename=N'sql_dependency_subscriber', @membername=N'Role'; -- ============================================= -- SCHEMA Restrictions -- ============================================= ... TO [Role]; -- Defined for each stored procedure need by Role. EXEC sys.sp_helprotect @Rolename=N'Role' END

... Fixed Server Role. You can use the following command to add your Login to the "sysadmin" server role. EXEC master..sp_addsrvrolemember @loginame = N'Test_Login', @rolename = N'sysadmin' Or, you can use SSMSE to perform this. Login to your SQL Server Instance as a System Administrator. Go to Security node and expand it. Go to ...

... to the sysadmin Fixed Server Role. You can use the following command to add your Login to the "sysadmin" server role. EXEC master..sp_addsrvrolemember @loginame = N'Test_Login', @rolename = N'sysadmin' Or, you can use SSMSE to perform this. Login to your SQL Server Instance as a System Administrator. Go to Security node and expand it. Go to ...

...Login to the sysadmin Fixed Server Role. You can use the following command to add your Login to the "sysadmin" server role. EXEC master..sp_addsrvrolemember @loginame = N'Test_Login', @rolename = N'sysadmin' Or, you can use SSMSE to perform this. Login to your SQL Server Instance as a System Administrator. Go to Security node and expand it. Go to properties of ...

... add your own Login to the sysadmin Fixed Server Role. You can use the following command to add your Login to the "sysadmin" server role. EXEC master..sp_addsrvrolemember @loginame = N'Test_Login', @rolename = N'sysadmin' Or, you can use SSMSE to perform this. Login to your SQL Server Instance as a System Administrator. Go to Security node and expand it. Go to properties of your ...

....0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b DriverAssembly=Borland.Data.DbxCommonDriver,Version=11.0.5000.0,Culture=neutral,PublicKeyToken=a91a7c5705831a4f Database=DATABASE.FDB RoleName= User_Name=sysdba Password=masterkey ServerCharSet= SQLDialect=3 BlobSize=-1 CommitRetain=False WaitOnLocks=True ErrorResourceFile= LocaleCode=0000 Interbase TransIsolation=ReadCommited Trim ...