Creating new user/privileges in 9i???

Hi,

I am new to the board and am having a problem creating a user in 9i on HP 11i.

I have a existing db created by 1 user (my_admin).

I created a role called NEW_USER and consists of the following statements:

GRANT ALL ON TABLE1 to NEW_USER;
GRANT ALL ON TABLE2 to NEW_USER; .................

I then create a new user (my_user) and

GRANT NEW_USER TO MY_USER;

When I log into SQLPlus as my_user and run a select statement, All of the objects (TABLE1, TABLE2, etc) do not exist under my new user.

Any help on what I am missing or doing wrong?

Thanks in advance!
Joe

You should do some reading about basic database stuff, like synonyms or full name notation (i.e. OWNER.TABLE_NAME). Oracle Concepts manual should be a good starting point....

Yeah, jmodic is right.

Try to give privileges to the role writing the user name, as:

GRANT ALL ON OWNER.TABLE1 to NEW_USER;
GRANT ALL ON OWNER.TABLE2 to NEW_USER;

Probably this will help.

Regards

Hi,
If those tables are owned by some other user, then create synonyms in my_user and then give all the grants to my_user. then you can see tables listed...

Thanks

Thanks for the help! I got it working.