Creating Oracle "read only" user

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?
 
Re: Creating Oracle \"read only\" user

Just search the Oracle Web Site for "public shutdown". Please ensure you are filtering on the EnterpriseOne Product line only.

The document is a little overkill if all you want is a single read only user but has all the concepts.

The only way to really do this effectively is to remove the Public permissions on all tables or to create views on all tables.

Colin
 
Back
Top