в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:55:07Z

1 версия

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

==add the additional ALL clause to a GRANT statement in order to grant all possible privileges==



<source lang="sql">

GRANT SELECT,INSERT,UPDATE,DELETE on EMPLOYEES TO oe;
GRANT ALL ON EMPLOYEES TO oe;

--

</source>

==Column-Level Object Privileges==



<source lang="sql">

GRANT UPDATE (product_id) ON sales01 TO salapati;
--

</source>

==Create a user and grant the permission==



<source lang="sql">

create user sqle identified by password;
grant create session, dba to sqle;
connect sqle/password;
--DROP USER sqle;

</source>

==Directory privileges: READ and WRITE==



<source lang="sql">

GRANT READ ON DIRECTORY bfile_dir TO userName;

</source>

==grant all on directory DirName to User==



<source lang="sql">

grant all on directory ext_data_files to scott
/

</source>

==grant one type or all types of privileges at once on any given object.==



<source lang="sql">

GRANT SELECT ON ods_process TO tester;
GRANT INSERT ON ods_process TO tester;
GRANT ALL ON ods_servers TO tester;
--

</source>

==Grant Permissions==



<source lang="sql">

SQL>
SQL> CREATE USER Alice IDENTIFIED BY simplepassword;
User created.
SQL>
SQL> GRANT SELECT, INSERT ON emp TO Alice WITH GRANT OPTION;
SQL>
SQL> drop user alice;
User dropped.
SQL>
SQL>
SQL>
SQL>

</source>

==Grant permission to system==



<source lang="sql">

grant select on george.mytable to system;

</source>

==Grant update permission==



<source lang="sql">

create table sprockets (
id number,
description varchar2(200),
quantity number )
/
grant update (id, description)
on sprockets
to scott;
insert into sprockets (id, description, quantity)
values( 1, "Titanium", 25 );
commit;
-- connect scott/tiger
update george.sprockets set quantity = 3;
update george.sprockets set description = "N";
drop table sprockets;

</source>

==Materialized view privileges: SELECT and QUERY REWRITE==



<source lang="sql">

GRANT QUERY REWRITE TO userName;

</source>

==Procedure, function, and package privileges: EXECUTE and DEBUG==



<source lang="sql">

GRANT EXECUTE ON employee_pkg TO hr;

</source>

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

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

в 13:45, 26 мая 2010

Admin: 1 версия