в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:55:05Z

1 версия

Новая страница

==Common System Privileges==



<source lang="sql">
Privilege Description
CREATE SESSION Enables a user to connect to the database instance.

CREATE TABLE Enables a user to create a table in his or her schema.
CREATE VIEW Enables a user to create a view in his or her schema.
CREATE SYNONYM Enables a user to create a private synonym in his or her schema.
CREATE PUBLIC SYNONYM Enables a user to create a synonym in the SYS schema that can be used by
any user in the database.
CREATE PROCEDURE Enables a user to create a stored procedure or function is his or her
schema.
CREATE SEQUENCE Enables a user to create a sequence in his or her schema.
CREATE TRIGGER Enables a user to create a trigger in his or her schema on a table in his
or her schema.
CREATE USER Enables a user to create another user in the database and specify the
password and other settings at creation time.
ALTER USER Enables a user to modify the user information of another user in the
database, including changing the user"s password.
DROP ANY TABLE Enables a user to drop any table in any schema in the database.
ALTER ANY TABLE Enables a user to alter any table in any schema in the database.
BACKUP ANY TABLE Enables a user to make a copy of any table in the database using the
Export utility (exp).
SELECT ANY TABLE Enables a user to issue a SELECT statement against any table
in the database.
INSERT ANY TABLE Enables a user to issue an INSERT statement against any table in
the database.
UPDATE ANY TABLE Enables a user to issue an UPDATE statement against any table in the
database.
DELETE ANY TABLE Enables a user to issue a DELETE statement against any table in the
database.

</source>

==Grant create related permission==



<source lang="sql">

GRANT create session
, create table
, create procedure
, create view
, create synonym
, create public synonym
, drop public synonym
, alter session
TO ppl;
</source>

==Grant permissions and then check the dba_col_privs table==



<source lang="sql">

grant references ( employee_id ),update( first_name,last_name,job_id,manager_id,department_id )
on hr.employees to scott;
select *
from dba_col_privs
/
</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/User Previliege/System Privileges - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия