| vikhardba |
Posted: Apr 27, 2007 04:45:08 PM |
Total Post: 86
Joined: Apr, 2007
|
Hi to everybody!!!
By using OEM control manager i have logged in as sysdba and assigned only select privilege to user 'HR' then applied, then from the DOS prompt i have connected to 'HR' user and tried to insert the rows ( just for testing ) and able to do that, whereas as i have just given select privilege. Wondering how it is possible?
Can anybody provide me detail solution with appropriate approach? |
|
|
 Ashu |
| Posted: Apr 27, 2007 09:50:51 PM |  |
|
Total Post: 13
Joined: Jan, 2007
|
Hi,
could you please elaborate on the question. You have granted select
privilege in which schema.
An user has all privileges for his own schema.
|
|
|
|
|
| vikhardba |
| Posted: Apr 28, 2007 01:55:15 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for your response. HR is the username and i have connected with same user and able to insert rows though sysdba has just assigned privilege for select stmt to 'HR' user. I hope u understood now.
|
|
|
|
|
| Ashu |
| Posted: Apr 29, 2007 08:17:01 AM | |
|
Total Post: 13
Joined: Jan, 2007
|
Hi,
HR has by default all the privileges on any of the objects that are made in his schema. This means that he can perform DDL,DML AND DCL commands on all of the objects. However, he will only be able to perform only actions for which he has been given privileges upon the objects that are belonging to other schema's.
Since, HR is working in his own schema, he can perform any of the commands
on tables in his schema.
|
|
|
|
|
| vikhardba |
| Posted: Apr 29, 2007 10:41:35 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
I am very much clear now. It sounds good. Thanks a million!!!!
|
|
|
|
|
| Ashu |
| Posted: Apr 29, 2007 01:41:48 PM | |
|
Total Post: 13
Joined: Jan, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
