i am trying to assign privileges to sde user and after choosing user and try to assign any role at least select error message appears: DBMS table not found ORA-00942
Edit i have traced and GDB_ITEMRELATIONSHIPS doesn't contain typeid of selected dataset
You cannot modify the System Tables manually, it is not supported and may corrupt the Database.
Can you provide us with more information of the steps followed and the data that you are trying to grant privileges on...
i am connecting as sde
1. connect to sde.
2. right click on selected feature dataset.
3. choose change privilege.
4. old privileges exist.
old created privileges works fine before
if u try to remove anyone u cant recreate again with ora-00942
if u try to set new privilege u got ora-00942
note: i am working on version