Re: User security
From: GeorgeP (GeorgeP_at_discussions.microsoft.com)
Date: 09/01/05
- Next message: jaylou: "Re: Create table rights"
- Previous message: ErwinB: "Re: Server Registration fails - figure this out !"
- In reply to: Hari Prasad: "Re: User security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 1 Sep 2005 09:05:34 -0700
Hari,
Yes I agree with you about this, but I have another user that is my backup
that promotes from staging to production. there are time when he needs to
add users, but I want to get an email whenever he does.
Thanks
"Hari Prasad" wrote:
> Hi,
>
> As a DBA you should be creating the Logins and users. Revoke all the admin
> prev. from other users/developers.
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "GeorgeP" <GeorgeP@discussions.microsoft.com> wrote in message
> news:7C94FB4C-55AD-4804-8113-5B876EF883DB@microsoft.com...
> >I was wondering since we cant add a trigger to sysusers or sysxlogins how
> >can
> > I be notified when ever a new users is added to a SQL server or one is
> > modified in a Database?
> >
> > TIA,
> > GP
>
>
>
- Next message: jaylou: "Re: Create table rights"
- Previous message: ErwinB: "Re: Server Registration fails - figure this out !"
- In reply to: Hari Prasad: "Re: User security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
