Re: automatically add grant to user
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Wed, 28 Jan 2015 03:00:05 +0700
Brian
have a look at grant ... ON DEFAULT.
SQL ref manual I think explains that
Stefan
On Jan 28, 2015 2:49 AM, "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
> I have a developer who asked me if there is a way to automatically grant
> a user select privs whenever a new table is created in a certain schema.
> Is that possible? I was thinking some type of trigger but haven’t really
> explored it yet. anybody get these types of requests and has something in
> place?
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
Other related posts:
