-
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....
Jurij Modic
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.
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
PNRDBA
-
Thanks for the help! I got it working.
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
|