Another security privilege, EXECUTE, allows users to run a PL/SQL procedure or
function. By default, the PL/SQL routine runs with the security privileges of the user
who compiled the routine. Alternately, you can specify that a PL/SQL routine run
with what is termed invoker??™s rights, which means that the routine is run with the
security privileges of the user who is invoking the routine.
Special Roles: DBA, SYSDBA, and SYSOPER
Your Oracle database comes with three special roles defined. The DBA role is one of
the most important default roles in Oracle. The DBA role includes most system
privileges. By default, it is granted to the users SYS and SYSTEM, both created at
database creation time. Base tables and data dictionary views are stored in the SYS
schema. SYSTEM schema tables are used for administrative information and by various
Oracle tools and options. A number of other administrative users also exist, as
consistent with the specific Oracle features deployed.
The DBA role does not include basic database administrative tasks included in the
SYSDBA or SYSOPER system privileges.
Pages:
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321