tag:blogger.com,1999:blog-13265058.post2678952446301215165..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: A quick example of proxy authenticationSydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-13265058.post-36665354979217099412013-11-19T14:21:19.481+11:002013-11-19T14:21:19.481+11:00I suspect there's extra issues involved in the...I suspect there's extra issues involved in the SYSTEM user that prevent proxy authentication working there.<br /><br />I'd be looking at other mechanism to 'delegate' SYSTEM functionality.<br /><br />Though a database trace would be interesting on working out the connection between an INSERT and changing a password. I'd suspect a trigger is involved.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-16298234577184648302013-11-17T06:42:00.205+11:002013-11-17T06:42:00.205+11:00Nice post!
I'm trying to achieve same thing. I...Nice post!<br />I'm trying to achieve same thing. I've 2 local users (schema1 user & schema2 user). Now I'm using schema1 user account to switch to schema2 tablespace and create/update tables.<br /><br />I'm able to SELECT the tables but can't insert or update..<br />Ran these queries:-<br />1) GRANT CONNECT, RESOURCE, CREATE ANY DIRECTORY, DROP ANY DIRECTORY TO user1;<br />2) ALTER USER system GRANT CONNECT THROUGH user1; commit;<br /><br />Error on INSERT query:-<br /><br />SQL Error: ORA-01031: insufficient privileges<br />01031. 00000 - "insufficient privileges"<br />*Cause: An attempt was made to change the current username or password<br />without the appropriate privilege. Kareshhttps://www.blogger.com/profile/08720348463035466988noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-82395831579595229342009-11-13T21:27:30.946+11:002009-11-13T21:27:30.946+11:00Sorry, my question has been caused by my overlooki...Sorry, my question has been caused by my overlooking the create procedure privilege lack on my development schema.YuriAPhttps://www.blogger.com/profile/14781383870484872725noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-62306179786097976002009-11-13T06:53:55.210+11:002009-11-13T06:53:55.210+11:00The devuser is only used for password authenticati...The devuser is only used for password authentication. When they connect as a proxy user to the schema account they will get all the privileges of that schema account.<br /><br />Just think of it as a way to have multiple, individual passwords for the same account.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-73252736557732808332009-11-12T23:27:36.503+11:002009-11-12T23:27:36.503+11:00Typical developers recompile schema objects such a...Typical developers recompile schema objects such as package. What kind of privileges they must have?YuriAPhttps://www.blogger.com/profile/14781383870484872725noreply@blogger.com