Totvs - RM - Usuários MSSQL - Versão 12.1 (RM)

/* 1º Parte */

 SP_DROPUSER SYSDBA
 GO
 EXEC SP_CHANGEDBOWNER sa
 GO

/* 2º Parte */

/* Criação dos usuários RM e SYSDBA */

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

GRANT SELECT ON GPARAMS TO sysdba
GO
GRANT SELECT , UPDATE ON GUSUARIO TO sysdba
GO
GRANT SELECT ON GPERMIS  TO sysdba
GO
GRANT SELECT ON GACESSO  TO sysdba
GO
GRANT SELECT ON GSISTEMA  TO sysdba
GO
GRANT SELECT ON GCOLIGADA  TO sysdba
GO
GRANT SELECT ON GUSRPERFIL TO sysdba
GO
GRANT SELECT ON GSERVICO TO sysdba
GO
GRANT SELECT ON GPARAMETROSSISTEMA TO sysdba
GO
GRANT SELECT,INSERT ON GDATALOG TO sysdba
GO
GRANT SELECT ON GMAILPARAMS TO sysdba
GO
GRANT SELECT ON GUPGATUALIZACAO TO sysdba
GO
GRANT SELECT,INSERT,DELETE,UPDATE ON GSESSAOFLUIG TO sysdba
GO
GRANT SELECT,INSERT,DELETE,UPDATE ON GULTIMOCONTEXTOUSUARIO TO sysdba
GO

SP_DEFAULTLANGUAGE 'RM','ENGLISH'
GO
SP_DEFAULTLANGUAGE 'SYSDBA','ENGLISH'
GO

Totvs - RM - Usuários - MSSQL 2012

/* 1º Parte */

 SP_DROPUSER SYSDBA
 GO
 EXEC SP_CHANGEDBOWNER sa
 GO

/* 2º Parte */

/* Criação dos usuários RM e SYSDBA */

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

GRANT SELECT ON GPARAMS TO sysdba
GO
GRANT SELECT , UPDATE ON GUSUARIO TO sysdba
GO
GRANT SELECT ON GPERMIS  TO sysdba
GO
GRANT SELECT ON GACESSO  TO sysdba
GO
GRANT SELECT ON GSISTEMA  TO sysdba
GO
GRANT SELECT ON GCOLIGADA  TO sysdba
GO
GRANT SELECT ON GUSRPERFIL TO sysdba
GO
GRANT SELECT ON GSERVICO TO sysdba
GO
GRANT SELECT ON GPARAMETROSSISTEMA TO sysdba
GO

Oracle - Alterar senha de usuário

Segue abaixo a linha de comando para alterar a senha de um usuário no Oracle

ALTER USER USUARIO IDENTIFIED BY SENHA

Sankhya/SQL - Usuários

Comando para adição de login no banco de dados MSSQLServer:


SQL 2000:
sp_change_users_login 'Auto_Fix', 'sankhya'

SQL 2005/2008:
sp_change_users_login 'Auto_Fix', 'sankhya',NULL,'tecsis'

RM/Oracle - Usuarios

Script de criação de usuários - Oracle

CREATE USER RM
IDENTIFIED BY RM
DEFAULT TABLESPACE RM_DADOS
TEMPORARY TABLESPACE RM_TMP;

CREATE USER SYSDBA
IDENTIFIED BY masterkey
DEFAULT TABLESPACE RM_DADOS
TEMPORARY TABLESPACE RM_TMP;


CREATE ROLE ACESSO_RM;

GRANT CONNECT,DBA,RESOURCE TO RM;

GRANT CONNECT, RESOURCE TO ACESSO_RM;

GRANT CONNECT,RESOURCE,ACESSO_RM TO SYSDBA;

ALTER USER SYSDBA
DEFAULT ROLE ALL;

RM/SQL - Script de Usuários - SQL 2000

Script de criação de usuários - SQL 2000


/* criação dos usuários */
/* inserida para delecao de usuarios*/
sp_configure 'allow updates','1'
go
reconfigure with override
go
select * from sysusers
go
delete from sysusers where name = '\rm'
go
delete from sysusers where name = 'sysdba'
go
select * from sysusers
go
if not exists(select * from master.dbo.syslogins where name = 'rm')
exec sp_addlogin rm,rm
go
sp_addalias rm,dbo
go
if not exists(select * from master.dbo.syslogins where name = 'sysdba')
exec sp_addlogin sysdba,masterkey
go
sp_adduser sysdba,sysdba,db_owner
go
grant select,insert,delete,update on gparams to sysdba
go
grant select,insert,delete,update on gusuario to sysdba
go
grant select,insert,delete,update on gpermis to sysdba
go
grant select,insert,delete,update on gacesso to sysdba
go
grant select,insert,delete,update on gsistema to sysdba
go
grant select,insert,delete,update on gcoligada to sysdba
go
grant select,insert,delete,update on gusrperfil to sysdba
go
sp_configure 'allow updates','0'
go
reconfigure with override
go

RM/SQL - Script de Usuários - SQL 2005

Script de criação de usuários - SQL 2005

IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = 'SYSDBA')
EXEC sp_dropuser 'SYSDBA'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = '\SYSDBA')
EXEC sp_dropuser 'SYSDBA'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = 'sysdba')
EXEC sp_dropuser 'sysdba'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = '\sysdba')
EXEC sp_dropuser 'sysdba'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = '\rm')
EXEC sp_dropalias 'rm'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = '\RM')
EXEC sp_dropalias 'RM'
GO
IF EXISTS(SELECT * FROM DBO.SYSUSERS WHERE NAME = '\RM')
EXEC sp_dropalias '\RM'

GO

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

EXEC sp_addalias rm,dbo
GO

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

EXEC sp_adduser sysdba,sysdba
GO

GRANT SELECT ON GPARAMS TO sysdba
GO
GRANT SELECT , UPDATE ON GUSUARIO TO sysdba
GO
GRANT SELECT ON GPERMIS TO sysdba
GO
GRANT SELECT ON GACESSO TO sysdba
GO
GRANT SELECT ON GSISTEMA TO sysdba
GO
GRANT SELECT ON GCOLIGADA TO sysdba
GO
GRANT SELECT ON GUSRPERFIL TO sysdba
GO
GRANT SELECT ON GSERVICO TO sysdba
GO

RM/SQL - Script de Usuários - SQL 2008

Script de criação de usuários - SQL 2008

SP_DROPUSER SYSDBA
GO
SP_DROPALIAS RM
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

GRANT SELECT ON GPARAMS TO sysdba
GO
GRANT SELECT , UPDATE ON GUSUARIO TO sysdba
GO
GRANT SELECT ON GPERMIS TO sysdba
GO
GRANT SELECT ON GACESSO TO sysdba
GO
GRANT SELECT ON GSISTEMA TO sysdba
GO
GRANT SELECT ON GCOLIGADA TO sysdba
GO
GRANT SELECT ON GUSRPERFIL TO sysdba
GO
GRANT SELECT ON GSERVICO TO sysdba
GO