-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|