-
How can I create a user who can only access his own schema? Can any body let me know the script for this?
Thanks.
zm
-
Unless you give him other Priviliges, he will have his own schema access.
Thanks
-
Hi,
Dont give him select any table system privilege.If u give that user select any table system privilege he can select from any schema also from SYS,if ur init.ora parameter
O7_dictionary_accessibilty=TRUE.
Also dont give him exclusive object privielege to select from other schema tables.
In case of any problems please be free to write to me at rohitsn@altavista.com
Regards,
Rohit Nirkhe
Oracle DBA,OCP
rohitsn@altavista.com
-
Well, strictly speaking, you can't make a user that can access only his own schema. All users have also access to objects granted to schema PUBLIC and there is no way you can prevent this. So if you create a user that has only CREATE SESSION privilege (is only able to connect to database, nothing else), he will still be able to select from DUAL, USER_* views etc etc...
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
create user mynewuser identified by mynewuserpwd (put storage parameters here);
grant create session to mynewuser;
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
|