OraFAQ Forum: Security » ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE

Home » RDBMS Server » Security » ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE (Oracle Database Enterprise 11gR2, 11.2.0.4.0, Windows Server 2012 r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE [message #663389]

Thu, 01 June 2017 14:42

licio.matos
Messages: 4
Registered: June 2017

Junior Member

Hi,

I'm get the error below when issuing the command above:

ALTER USER XXXX GRANT CONNECT THROUGH YYYY WITH ROLE ROLE_APP;

ORA-01924 - "role '%s' not granted or does not exist"

This work on version 11.2.0.1.0 and 11.2.0.3.0, the role exist.

Anyone knows if this is a bug?

Tks All.

Report message to a moderator

[Message index]

		ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: licio.matos on Thu, 01 June 2017 14:42
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: Michel Cadot on Thu, 01 June 2017 14:51
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: John Watson on Thu, 01 June 2017 14:51
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: Michel Cadot on Thu, 01 June 2017 14:55
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: Barbara Boehmer on Thu, 01 June 2017 15:34
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: licio.matos on Fri, 02 June 2017 05:25
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: cookiemonster on Fri, 02 June 2017 05:38
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: Michel Cadot on Fri, 02 June 2017 05:42
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: licio.matos on Fri, 02 June 2017 05:57
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: Michel Cadot on Fri, 02 June 2017 06:01
		Re: ORA-01924 - ALTER USER...GRANT CONNECT THROUGH APPSFER WITH ROLE By: licio.matos on Fri, 02 June 2017 06:11

Previous Topic:	Audit specific statment on specific table by specific user
Next Topic:	Begin to manage and make security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:13:33 CDT 2024