اذهب الي المحتوي
المنتصر

مشكلة فى Oracle10 Designer

Recommended Posts

المنتصر

 

السلام عليكم ورحمة الله وبركاته

 

 

انا عندى مشكلة فى oracle10g designer  عند الدخول على  Design Editor  وعمل  Relation table Definitions

تخرج Message التالية

CDD-22001: You do not have update and/or insert access rights for Folder SYSTEM FOLDER. Continue ?

 

علما بأن المستخدم عنده جميع الصلاحيات 

;GRANT EXECUTE ON DBMS_LOCK TO user

       GRANT EXECUTE ON DBMS_PIPE TO user;

GRANT EXECUTE ON DBMS_RLS TO user;

GRANT SELECT ON dba_rollback_segs TO user;

GRANT SELECT ON dba_segments TO user;

GRANT SELECT ON sys.v_$nls_parameters TO user WITH GRANT OPTION;

GRANT SELECT on V_$PARAMETER TO user;

GRANT ALTER SESSION TO user;

GRANT CREATE ANY SYNONYM TO user;

GRANT CREATE SESSION TO user;

GRANT CREATE DATABASE LINK TO user;

GRANT CREATE PROCEDURE TO user;

GRANT CREATE ROLE TO user;

GRANT CREATE SEQUENCE TO user;

GRANT CREATE SESSION TO   user;

GRANT CREATE TABLE TO user;

GRANT CREATE TRIGGER TO   user;

GRANT CREATE TYPE TO user;

GRANT CREATE VIEW TO   user;

GRANT DROP ANY SYNONYM TO   user;

GRANT SELECT ANY SEQUENCE TO   user;

GRANT CREATE PUBLIC SYNONYM TO  user;

grant execute on dbms_lock to  user;

grant execute on dbms_pipe to  user;

grant execute on dbms_rls to  user;

grant select on dba_rollback_segs to user;

grant select on dba_segments to user;

grant select on v_$nls_parameters to user;

grant select on v_$parameter to  user;

 

 

شارك هذه المشاركه


رابط المشاركه
شارك
sdkdev

 

Grant Access Rights to Users

The user who owns a workarea, container or configuration can grant access rights on that item to other users, or revoke them from those users.

If you have created subordinate users, test the access rights mechanism as follows:

  1. In the Repository Object Navigator, choose File > Access Rights > View Access Rights.
  2. Check the current access rights on the test workarea and container that you created earlier.
  3. Grant (at least) the Select access right on the workarea and container to one of the subordinate users.
  4. Change the connection to that user.
  5. Check that the user can see the workarea (under Shared Workareas) and the container.
  6. Change the connection back to the repository owner and revoke the access rights.

To grant an access right to all subordinate users (present or future), grant it to PUBLIC.

 

 

Note:

If you have enabled version control, remember to grant the Version access right on an object to any users who will be using version control with that object. 

شارك هذه المشاركه


رابط المشاركه
شارك

انشئ حساب جديد او قم بتسجيل دخولك لتتمكن من اضافه تعليق جديد

يجب ان تكون عضوا لدينا لتتمكن من التعليق

انشئ حساب جديد

سجل حسابك الجديد لدينا في الموقع بمنتهي السهوله .

سجل حساب جديد

تسجيل دخول

هل تمتلك حساب بالفعل ؟ سجل دخولك من هنا.

سجل دخولك الان

×
×
  • اضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: إتفاقية الخصوصية