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