Re: automatically granting access to schema objects???

Create a Role which consists of the Security issues in question. Instead of granting select, update...
on a specific Table or View to a user, you grant it to the Role. Then assign that Role to the user(s).

Note. You can assign multiple roles to the same user.

Greg Vitetzakis

mdlcpgs_at_alpha.gns.cri.nz.nospam wrote in article <6i0dup$due$1_at_news.wlg.netlink.net.nz>...
> I am having trouble setting up user accounts secirty wise. What I want is
> to grant privilege to a user so they can select from any table/view in a
> particular schema. I find if I add a object to the schema, I have
explicitly
> grant access to it to all the relevant users. Any way around this?
> (programmer acting as very new DBA till co gets round to hiring one..)
>
Received on Sun Apr 26 1998 - 19:47:36 CDT