Create View only user

[dilipkumar.mandal]

Hi,

We want to create one user who should have menu same as ADMIN but all data should be view only.
By VPD we can restrict. But we have to select tables one by one. Is there any way to give ALL Table at once?
Is there any other way to create user with read only access of all data?

Thanks,
Dilip

[anirban1982]

Re: Create View only user

You can use Levels and Assigned Functions, remove all update functions from there. Assign it to a user role, assign the user role to the user.

Regards,
Anirban Roy

[nipunlakhotia]

Re: Create View only user

Hi Dilip,

Create a new User Role -"View_Only" with Level ="View". Assign this role to UserID to whom to wish to give read only access