[ORACLE] GRANT 권한부여

2021-08-16
  • CREATE USER
create user shop identified by 1234;
  • GRANT ALL TO USER
GRANT ALL PRIVILEGES TO shop;
  • GRANT SESSION ROLL
CREATE ROLE PLUSTRACE;
GRANT select ON V_$SESSTAT TO PLUSTRACE;
GRANT select ON V_$STATNAME TO PLUSTRACE;
GRANT select ON v_$SESSION TO PLUSTRACE;
GRANT PLUSTRACE TO dba with admin option;
GRANT PLUSTRACE TO shop;