Home » RDBMS Server » Security » what is wrong here
what is wrong here [message #613032] Tue, 29 April 2014 00:58 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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

Re: what is wrong here [message #613036 is a reply to message #613032] Tue, 29 April 2014 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In addition, from your previous topic:

BlackSwan wrote on Mon, 28 April 2014 15:04
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Re: what is wrong here [message #613038 is a reply to message #613036] Tue, 29 April 2014 01:17 Go to previous messageGo to next message
ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka
Junior Member
Thanq Mad got it....
Re: what is wrong here [message #613041 is a reply to message #613038] Tue, 29 April 2014 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So what was it?

Re: what is wrong here [message #613042 is a reply to message #613041] Tue, 29 April 2014 01:46 Go to previous message
ishan2ma
Messages: 13
Registered: April 2014
Location: Srilanka
Junior Member
GRANT SELECT TABLE TO hr_mgr;
Previous Topic: Reset SYS Account
Next Topic: unable to capture audit on ALTER PROCEDURE...COMPILE
Goto Forum:
  


Current Time: Fri Mar 29 01:42:50 CDT 2024