الدرس الاول مستخدم لة صلاحيات الديزاينر

[ayman_tamim]

بعض من الصلاحيات التى يجب ان يحصل عليها مستخدم الديزاينر
و لنجعل اسمه
repos_owner


--increase system tablespace size
ALTER TABLESPACE "SYSTEM" ADD DATAFILE
'F:\ORA81\ORADATA\ORACLE\SYSTEM02.DBF' SIZE 250M;

-- create the default tablespace for repos_owner user
CREATE TABLESPACE "DES" LOGGING DATAFILE
'F:\ORA81\ORADATA\ORACLE\DES.DBF' SIZE 300M;

-- connect as sysdba user ... better use the SYS/CHANGE_ON_INSTALL as
SYSDBA
-- create the repos_owner user
create user repos_owner identified by MANAGER default tablespace DES
temporary tablespace DES;

-- under the oracle home
@F:\ORA81\RDBMS\ADMIN\dbmspool.sql
-- under the designer home
@F:\ORANT\REPADM61\UTL\CKROROLE.SQL


-- connect as SYSTEM and run these commands
grant execute on dbms_lock to repos_owner;
grant execute on dbms_pipe to repos_owner;
grant create table to repos_owner;
grant create view to repos_owner;
grant create procedure to repos_owner;
grant create synonym to repos_owner;
grant create sequence to repos_owner;
grant select on sys.v_$nls_parameters to repos_owner with grant option;
grant select on sys.v_$parameter to repos_owner;
grant select on dba_rollback_segs to repos_owner;
grant select on dba_segments to repos_owner;
grant create any synonym to repos_owner;
grant drop any synonym to repos_owner;
grant create public synonym to repos_owner;
grant drop public synonym to repos_owner;
grant ck_oracle_repos_owner to repos_owner;
grant connect, resource to repos_owner;