Tuesday, February 26, 2013

How to create read only user in oracle Apps database

Use the below step to create a read only user who can have select privilege in oracle for all apps objects.

create user readonly identified by readonly default tablespace users temporary tablespace temp;
grant connect, select any table to readonly;

3 comments:

Anonymous said...

Evеry weеkеnd i used tο gо to see this web pagе,
foг the reаson that i wаnt enjoуment,
fоr the reason that this this wеb pagе conatiοns genuinely niсe funny ѕtuff too.


Visit my blog ρost www.linksnoop.com

Anonymous said...

Thanks for sharing youг thοughts аbout iphοne 4 chеap cases.

Regardѕ

Here iѕ my blog: iphone 4S case

Anonymous said...

It's wonderful that you are getting ideas from this piece of writing as well as from our discussion made here.

my web blog: best iphone accessories