SP_DROPUSER SYSDBA
GO

IF NOT EXISTS(SELECT * FROM MASTER.DBO.SYSLOGINS WHERE NAME = 'rm')
   CREATE LOGIN rm WITH PASSWORD = 'rm',CHECK_POLICY=OFF
GO

EXEC SP_CHANGEDBOWNER rm
GO

IF NOT EXISTS(SELECT * FROM MASTER.DBO.SYSLOGINS WHERE NAME = 'sysdba')
   CREATE LOGIN sysdba WITH PASSWORD = 'masterkey',CHECK_POLICY=OFF
GO
 
sp_adduser sysdba,sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GPARAMS' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GPARAMS TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GUSUARIO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT , UPDATE ON GUSUARIO TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GPERMIS' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GPERMIS TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GACESSO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GACESSO TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GSISTEMA' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GSISTEMA TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GCOLIGADA' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GCOLIGADA TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GUSRPERFIL' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GUSRPERFIL TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GSERVICO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GSERVICO TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GPARAMETROSSISTEMA' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GPARAMETROSSISTEMA TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GDATALOG' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT,INSERT ON GDATALOG TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GSECPROVIDER' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GSECPROVIDER TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GMAILPARAMS' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GMAILPARAMS TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GUPGATUALIZACAO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT ON GUPGATUALIZACAO TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GSESSAOFLUIG' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT,INSERT,DELETE,UPDATE ON GSESSAOFLUIG TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GULTIMOCONTEXTOUSUARIO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT SELECT,INSERT,DELETE,UPDATE ON GULTIMOCONTEXTOUSUARIO TO sysdba
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GCRITICALLOG' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT INSERT,DELETE, SELECT, UPDATE ON GCRITICALLOG TO SYSDBA
GO

IF EXISTS(SELECT 1 FROM SYS.OBJECTS WHERE NAME = 'GCRITICALLOGDADO' AND SCHEMA_ID = SCHEMA_ID('DBO'))
    GRANT INSERT,DELETE, SELECT, UPDATE ON GCRITICALLOGDADO TO SYSDBA
GO

SP_DEFAULTLANGUAGE 'RM','ENGLISH'
GO

SP_DEFAULTLANGUAGE 'SYSDBA','ENGLISH'
GO

USE MASTER
GO

GRANT VIEW SERVER STATE to RM
GO