Sistemske
privilegije konektovanog korisnika
Role
dodeljene konektovanom korisniku
set
ORACLE_SID=test
set
ORACLE_HOME=D:\oracle\product\10.2.0\db_1
SYSDBA
i SYSOPER sistemske privilegije dozvoljavaju korišćenje instance baze čak i kada
baza nije otvorena. Kontrola ovih privilegija
je potpuno van baze.
Na primer, … ako imate
SYSDBA privilegiju možete
se konektovati korišćenjem
CONNECT AS SYSDBA sintakse.
D:\download\rda_tool\rda>sqlplus
SQL*Plus:
Release 10.2.0.1.0 - Production on Mon Oct 30 16:32:58 2006
Copyright
(c) 1982, 2005, Oracle. All rights
reserved.
Enter
user-name: / as sysdba
Connected
to:
Oracle
Database 10g
With
the Partitioning, OLAP and Data Mining options
SQL>
show user
USER
is "SYS“
--
KOJI KORISNICI TRENUTNO POSTOJE U BAZI
1* select * from all_users
SQL>
/
USERNAME USER_ID CREATED
------------------------------
---------- ---------
DEV 67
09-OCT-06
APEXDEV 66 09-OCT-06
FLOWS_020200 65 09-OCT-06
USER_TS2 62 02-OCT-06
FLOWS_FILES 63 09-OCT-06
APEXDEV1 72 20-OCT-06
TEST 71 17-OCT-06
APEX_PUBLIC_USER 64 09-OCT-06
BI 60
14-SEP-06
PM 59
14-SEP-06
SH 58
14-SEP-06
IX 57 14-SEP-06
OE 56
14-SEP-06
HR 55
14-SEP-06
SCOTT 54 30-AUG-05
MGMT_VIEW 53 30-AUG-05
MDDATA 50 30-AUG-05
SYSMAN 51 30-AUG-05
MDSYS 46 30-AUG-05
SI_INFORMTN_SCHEMA 45 30-AUG-05
ORDPLUGINS 44 30-AUG-05
ORDSYS 43 30-AUG-05
OLAPSYS 47 30-AUG-05
ANONYMOUS 39 30-AUG-05
XDB 38
30-AUG-05
CTXSYS 36 30-AUG-05
EXFSYS 34 30-AUG-05
WMSYS 25 30-AUG-05
DBSNMP 24 30-AUG-05
TSMSYS 21 30-AUG-05
DMSYS 35 30-AUG-05
DIP 19
30-AUG-05
OUTLN 11 30-AUG-05
SYSTEM 5 30-AUG-05
SYS 0
30-AUG-05
35
rows selected.
……
SQL>
select * from dict where table_name
like 'USER_SYS_PRIVS'
/
TABLE_NAME COMMENTS
--------------
------------------------------------------------
USER_SYS_PRIVS
System privileges granted to current user
--KOJE
SU MOJE SISTEMSKE PRIVILEGIJE
SQL>
SELECT USERNAME,PRIVILEGE FROM USER_SYS_PRIVS;
USERNAME PRIVILEGE
------------------------------
---------------------------------
SYS CREATE EXTERNAL JOB
SYS MANAGE FILE GROUP
SYS ADMINISTER SQL TUNING SET
SYS MANAGE SCHEDULER
SYS CREATE ANY RULE
SYS CREATE ANY
EVALUATION CONTEXT
SYS CREATE ANY CONTEXT
SYS MANAGE ANY QUEUE
SYS ALTER ANY INDEXTYPE
SYS CREATE ANY
MATERIALIZED VIEW
SYS EXECUTE ANY
PROCEDURE
SYS ALTER ANY ROLE
SYS GRANT ANY ROLE
SYS DROP PUBLIC
DATABASE LINK
SYS CREATE DATABASE
LINK
SYS CREATE ANY INDEX
SYS ALTER ANY CLUSTER
SYS ALTER ROLLBACK
SEGMENT
SYS ALTER SESSION
SYS AUDIT SYSTEM
SYS DROP ANY SQL
PROFILE
SYS ALTER ANY RULE
SYS IMPORT FULL DATABASE
SYS CREATE RULE SET
SYS EXECUTE ANY
EVALUATION CONTEXT
SYS FLASHBACK ANY TABLE
SYS CREATE ANY
DIMENSION
SYS EXECUTE ANY INDEXTYPE
SYS DROP ANY INDEXTYPE
SYS CREATE ANY
INDEXTYPE
SYS CREATE ANY OPERATOR
SYS CREATE LIBRARY
SYS CREATE ANY DIRECTORY
SYS CREATE PROFILE
SYS CREATE VIEW
SYS INSERT ANY TABLE
SYS SELECT ANY TABLE
SYS LOCK ANY TABLE
SYS DROP ANY TABLE
SYS MANAGE ANY FILE
GROUP
SYS CREATE ANY SQL
PROFILE
SYS EXECUTE ANY CLASS
SYS CREATE ANY JOB
SYS ADVISOR
SYS EXPORT FULL
DATABASE
SYS RESUMABLE
SYS DROP ANY OUTLINE
SYS DROP ANY DIMENSION
SYS UNDER ANY TABLE
SYS EXECUTE ANY LIBRARY
SYS DROP ANY LIBRARY
SYS CREATE ANY LIBRARY
SYS ALTER ANY TYPE
SYS DROP ANY ROLE
SYS CREATE ROLE
SYS DROP ANY SEQUENCE
SYS ALTER ANY SEQUENCE
SYS CREATE SEQUENCE
SYS CREATE PUBLIC SYNONYM
SYS UPDATE ANY TABLE
SYS CREATE ROLLBACK
SEGMENT
SYS UNLIMITED
TABLESPACE
SYS CREATE TABLESPACE
SYS CHANGE NOTIFICATION
SYS ADMINISTER ANY SQL
TUNING SET
SYS DROP ANY RULE SET
SYS DEBUG ANY PROCEDURE
SYS ENQUEUE ANY QUEUE
SYS EXECUTE ANY TYPE
SYS CREATE ANY TRIGGER
SYS CREATE ANY
PROCEDURE
SYS ALTER DATABASE
SYS DROP ANY VIEW
SYS CREATE ANY VIEW
SYS CREATE SYNONYM
SYS DROP ROLLBACK
SEGMENT
SYS DROP USER
SYS CREATE USER
SYS ALTER ANY SQL
PROFILE
SYS CREATE RULE
SYS ALTER ANY
EVALUATION CONTEXT
SYS CREATE EVALUATION
CONTEXT
SYS ON COMMIT REFRESH
SYS MERGE ANY VIEW
SYS CREATE ANY OUTLINE
SYS DROP ANY CONTEXT
SYS GLOBAL QUERY
REWRITE
SYS QUERY REWRITE
SYS UNDER ANY VIEW
SYS CREATE INDEXTYPE
SYS CREATE ANY TYPE
SYS CREATE TYPE
SYS DROP ANY DIRECTORY
SYS DROP ANY
MATERIALIZED VIEW
SYS ANALYZE ANY
SYS ALTER PROFILE
SYS FORCE ANY
TRANSACTION
SYS AUDIT ANY
SYS DROP ANY INDEX
SYS CREATE ANY CLUSTER
SYS ALTER ANY TABLE
SYS CREATE SESSION
SYS ALTER SYSTEM
SYS CREATE JOB
SYS EXECUTE ANY RULE
SYS DROP ANY EVALUATION
CONTEXT
SYS GRANT ANY OBJECT
PRIVILEGE
SYS ALTER ANY OUTLINE
SYS ALTER ANY LIBRARY
SYS DROP ANY TYPE
SYS GRANT ANY PRIVILEGE
SYS ALTER RESOURCE COST
SYS ALTER ANY TRIGGER
SYS CREATE TRIGGER
SYS FORCE TRANSACTION
SYS DROP ANY CLUSTER
SYS CREATE CLUSTER
SYS COMMENT ANY TABLE
SYS CREATE ANY TABLE
SYS RESTRICTED SESSION
SYS SELECT ANY TRANSACTION
SYS EXECUTE ANY PROGRAM
SYS EXECUTE ANY RULE
SET
SYS ALTER ANY RULE SET
SYS DEQUEUE ANY QUEUE
SYS ALTER ANY DIMENSION
SYS DROP ANY OPERATOR
SYS CREATE MATERIALIZED
VIEW
SYS ALTER ANY PROCEDURE
SYS CREATE PROCEDURE
SYS CREATE ANY SEQUENCE
SYS DROP PUBLIC SYNONYM
SYS ALTER ANY INDEX
SYS DELETE ANY TABLE
SYS CREATE TABLE
SYS ALTER USER
SYS BECOME USER
SYS DROP TABLESPACE
SYS ALTER TABLESPACE
SYS READ ANY FILE GROUP
SYS DROP ANY RULE
SYS CREATE ANY RULE SET
SYS DEBUG CONNECT
SESSION
SYS ADMINISTER DATABASE
TRIGGER
SYS ADMINISTER RESOURCE
MANAGER
SYS CREATE DIMENSION
SYS EXECUTE ANY
OPERATOR
SYS CREATE OPERATOR
SYS UNDER ANY TYPE
SYS ALTER ANY
MATERIALIZED VIEW
SYS DROP PROFILE
SYS DROP ANY TRIGGER
SYS DROP ANY PROCEDURE
SYS CREATE PUBLIC
DATABASE LINK
SYS SELECT ANY SEQUENCE
SYS DROP ANY SYNONYM
SYS CREATE ANY SYNONYM
SYS BACKUP ANY TABLE
SYS MANAGE TABLESPACE
159
rows selected.
SQL>
select * from dict where table_name
like 'USER_ROLE_PRIVS'
/
TABLE_NAME
------------------------------
COMMENTS
---------------------------------------------------------------
USER_ROLE_PRIVS
Roles
granted to current user
SQL>
SELECT USERNAME,GRANTED_ROLE FROM USER_ROLE_PRIVS;
USERNAME GRANTED_ROLE
------------------------------
-------------------------
SYS
AQ_ADMINISTRATOR_ROLE
SYS AQ_USER_ROLE
SYS AUTHENTICATEDUSER
SYS CONNECT
SYS CTXAPP
SYS DBA
SYS DELETE_CATALOG_ROLE
SYS EJBCLIENT
SYS
EXECUTE_CATALOG_ROLE
SYS EXP_FULL_DATABASE
SYS
GATHER_SYSTEM_STATISTICS
SYS HS_ADMIN_ROLE
SYS IMP_FULL_DATABASE
SYS JAVADEBUGPRIV
SYS JAVAIDPRIV
SYS JAVASYSPRIV
SYS JAVAUSERPRIV
SYS JAVA_ADMIN
SYS JAVA_DEPLOY
SYS
LOGSTDBY_ADMINISTRATOR
SYS MGMT_USER
SYS OEM_ADVISOR
SYS OEM_MONITOR
SYS OLAP_DBA
SYS OLAP_USER
SYS PLUSTRACE
SYS RECOVERY_CATALOG_OWNER
SYS RESOURCE
SYS SCHEDULER_ADMIN
SYS SELECT_CATALOG_ROLE
SYS XDBADMIN
SYS XDBWEBSERVICES
32
rows selected.