Creating new user/privileges in 9i???
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!
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....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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.
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 for the help! I got it working.
Click Here to Expand Forum to Full Width