topic ora-00942 strange issue in Data Management Questions

ora-00942 strange issue

AmrAdel1 — Tue, 17 Jan 2017 00:15:55 GMT

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

Re: ora-00942 strange issue

Asrujit_SenGupta — Tue, 17 Jan 2017 05:33:11 GMT

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...

Re: ora-00942 strange issue

AmrAdel1 — Tue, 17 Jan 2017 06:36:42 GMT

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

Re: ora-00942 strange issue

AmrAdel1 — Wed, 18 Jan 2017 06:30:37 GMT

any kind of help