Database Security Products (MOSC)

MOSC Banner

PROXY ONLY CONNECT returning error

Hi,

I have a question about Proxy user.

 From DBA account, we defined a proxy user like:

CREATE USER WEBPROXY IDENTIFIED BY mypassword

/

GRANT CREATE SESSION TO WEBPROXY

/

ALTER USER WEBPROXY PROXY ONLY CONNECT

/

alter user isaa grant connect through WEBPROXY

/


At a new connection, if I try:


connect WEBPROXY[isaa]/mypassword


I will receive the error: ora-28058


Only, if I perform the next statement to change the proxy user definition:


ALTER USER WEBPROXY CANCEL PROXY ONLY CONNECT

/


the : connect WEBPROXY[isaa]/mypassword will be success


So in which way it's possible to avoid the connection of the proxy user self (webproxy) ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center