Is the role set as her default role? Having the role is not enough.
You can have a role assigned to you but its not necessarily 'active'
at the time.
-Original Message-
Sent: Wednesday, January 02, 2002 4:30 AM
To: Multiple recipients of list ORACLE-L
I granted myself roles via SYS.
Hi
You own the objects, and the other user can't see them?
Try creating synonyms or add the schemaname in front of the object.
---select * from owner.table;
what roles did you grant (connect resource dba. or something you
created yourself)?
A little more info would help in resolving pro
Title: RE: Problem Granting Roles
What exactly is the error message - if it is table or view does not exist (ORA-904) then I suspect that it is synonyms that are not working/created.
get the user to select from the full table name sys.x and see what happens.
-Original Message
I granted myself roles via SYS. I have another user on our server (W2000 /
8.1.7) and I have gone through the same process of granting the new user
roles via SYS. However, when she connects to the DB she gets the message
that the objects don't exist. The owner of the DB is me. What am I doing
