privileges inbulit schemas have
Posted on 2001-07-22
soctt/tiger is a default schema of oracle. Are privileges granted to it individually, via a role or automatically as part of the installation process. Same is my question on any of the following schemas. Please indicate which of them have DBA privileges.
SYS, SYSTEM, OUTLN, DBSNMP, AURORA$ORB$UNAUTHENTICATED,ORDSYS,ORDPLUGINS,MDSYS, CTXSYS, ADAMS,JONES, CLARK and BLAKE.
How to know all the privileges assigned to the above schemas. Can we grant/revoke to/from individually or as as a role. Please be elaborate so that i can grade immediately. Can you tell me the difference between a schema and a user.