wloban
Well Known Member
Creating Oracle \"read only\" user
Has anyone created a "read only" user outside of E1? Oracle gave a solution
1. )If the user needs a select privilege on some tables and views then :
1.a) Make a list of tables and views.
1.b) Create a database role
1.d) Grant select privilege on these tables and views to the newly created role .
1.e) Assign this role to the users in concern .
All of the tables in CRPDTA where given the select object privilege to the role.
But because of the public role the readonly role can also update the database.
Does anyone know a way around this?
Has anyone created a "read only" user outside of E1? Oracle gave a solution
1. )If the user needs a select privilege on some tables and views then :
1.a) Make a list of tables and views.
1.b) Create a database role
1.d) Grant select privilege on these tables and views to the newly created role .
1.e) Assign this role to the users in concern .
All of the tables in CRPDTA where given the select object privilege to the role.
But because of the public role the readonly role can also update the database.
Does anyone know a way around this?