[OAUGNet]-Read-only database account

["Shingireddy, Ahalya" <Ahalya.Shingireddy@otsuka.com>]

What are the best practices done for the read-only database accounts in production while giving access to super-user/developers? This came up as a part of our audit process.

I am looking for a script to create a read-only account for apps, which can access (select only) from all apps tables without specifying the schema owner.  Can anybody please share the script if you already have one?

Thanks for your suggestion.
Ahalya


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>