الانتقال إلى المحتوى

مشكلة فى 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;

 

 

رابط هذا التعليق
شارك

  • بعد 5 شهور...

 

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. 

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

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

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