ora-00942 strange issue

Question

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

AmrAdel1 · Answer

any kind of help

AmrAdel1 · Answer

i am connecting as sde

steps :

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

Asrujit_SenGupta · Answer

You cannot modify the System Tables manually, it is not supported and may corrupt the Database.

* Are you using the "Change Privilege" tool?
* Are you connected as the owner of the data?

Can you provide us with more information of the steps followed and the data that you are trying to grant privileges on...