| what is wrong here [message #613032] |
Tue, 29 April 2014 00:58  |
 |
ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka
|
Junior Member |
|
|
CREATE ROLE hr_mgr IDENTIFIED BY hr_pass;
GRANT CONNECT TO hr_mgr;
GRANT CREATE TABLE TO hr_mgr;
GRANT SELECT TABLE TO hr_mgr;
GRANT hr_mgr TO scott;
This is not working Y is that please help me which line causes the error
|
|
|
|
| Re: what is wrong here [message #613035 is a reply to message #613032] |
Tue, 29 April 2014 01:08  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
What does "this is not working" mean?
Ah, there's no SELECT TABLE privilege (but there is SELECT ANY TABLE), if that's what you meant.
Also, consider NOT using the CONNECT role. Since 10g R2, it contains CREATE SESSION only, so - to avoid confusion - grant CREATE SESSION instead (of course, if you're on 10g R2 or later).
[Updated on: Tue, 29 April 2014 01:12] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
got it....