| Author |
transfer users and permissions
|
|
|
| I am new to SQL. I am trying to create a trigger for whenever a new user or
permission has been added modified or deleted from a .net application
database I need the trigger to update this info into the production database.
Can someone tell how can I do this?
Thank you
| |
| Joe Yong 2005-11-14, 8:24 pm |
| Have you looked into DDL Triggers? Create_User is one of the events that
will fire the trigger.
joe.
"Amit" <Amit@discussions.microsoft.com> wrote in message
news:A60E40DD-5888-4AAA-82C1- B798E0F5A6AA@microso
ft.com...
>I am new to SQL. I am trying to create a trigger for whenever a new user or
> permission has been added modified or deleted from a .net application
> database I need the trigger to update this info into the production
> database.
> Can someone tell how can I do this?
> Thank you
| |
|
| Can you tell me more about create_user as in does it fire up whenever there
is any kind of an update. Also how do I get this trigger?
thanks
Amit
"Joe Yong" wrote:
> Have you looked into DDL Triggers? Create_User is one of the events that
> will fire the trigger.
>
>
> joe.
>
> "Amit" <Amit@discussions.microsoft.com> wrote in message
> news:A60E40DD-5888-4AAA-82C1- B798E0F5A6AA@microso
ft.com...
>
>
>
| |
|
| Also I am currently using sql server 2000 and not 2005
"Amit" wrote:
[color=darkred]
> Can you tell me more about create_user as in does it fire up whenever there
> is any kind of an update. Also how do I get this trigger?
> thanks
> Amit
>
> "Joe Yong" wrote:
>
|
|
|
|