Meddata User Grant User Oluşturma, Scriptleri

				
					--HastaneUser

DROP USER HASTANE CASCADE;

CREATE ROLE "DOKTOR" NOT IDENTIFIED;

GRANT "CONNECT" TO "DOKTOR";

GRANT "DBA" TO "DOKTOR";

CREATE ROLE "IDARECI" NOT IDENTIFIED;

GRANT "CONNECT" TO "IDARECI";

GRANT "DBA" TO "IDARECI";

CREATE USER "HASTANE" PROFILE "DEFAULT"

IDENTIFIED BY "hastane" DEFAULT TABLESPACE "USERS"

ACCOUNT UNLOCK;

GRANT "CONNECT" TO "HASTANE";

GRANT "DBA" TO "HASTANE";

GRANT "DOKTOR" TO "HASTANE";

GRANT "IDARECI" TO "HASTANE";

DROP USER MEDDATAPACS CASCADE;
 

 

--MeddataPacsUser

 
CREATE USER MEDDATAPACS

IDENTIFIED BY MEDDATAPACS

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

-- 2 Roles for MEDDATAPACS

GRANT CONNECT TO MEDDATAPACS;

GRANT DBA TO MEDDATAPACS;

ALTER USER MEDDATAPACS DEFAULT ROLE ALL;

-- 1 System Privilege for MEDDATAPACS

GRANT UNLIMITED TABLESPACE TO MEDDATAPACS;