Re: Users on a DB are dropped without any intervention

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 07/30/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Tue, 30 Jul 2002 10:18:56 -0400

My guess would be that someone is dropping and recreating objects but not
re-establishing the permissions for all the users. For instance if you go
to upgrade a stored proc that the user has rights to execute with a DROP
PROC and then CREATE PROC... the user will loose any permissions on it
unless they are restored. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
"pat" <pwfitzgerald@hotmail.com> wrote in message
news:2f3401c237d0$e5489660$3bef2ecf@TKMSFTNGXA10...
> I add a new user and give him DB rights in specific
> databases.  The user works for a few weeks within each
> database then they will come in one day and will have lost
> rights in a couple of the databases that they had rights
> in the previous day.  I haven't touched their security
> settings at all.  The user has no way to mess with the
> security settings.  But, sure as day, they are unable to
> work in a specific DB because they no longer have rights
> in that DB.  The users rights were originally added
> programmatically.  When they lose their rights
> unexpectedly, I go back and add the security back using
> EM.  A few weeks later, the whole cycle starts over again
> with that same user.  It's become a continuous job giving
> users their rights in databases where they have lost their
> rights... fun fun.  I Can't establish any pattern... seems
> to be random to me.  Can anyone shed some light??  thanks

Relevant Pages

  • Re: Password required for Reports
    ... IIS permissions are Read which match our Central site which works. ... Authentication is Integrated Windows Authentication. ... I know everyone is thinking it's a rights issue but I've checked the ... Reapplied security rights - no luck ...
    (microsoft.public.sms.admin)
  • Re: Problem sending emails
    ... you may want to review the security you've put into place and undo it to see ... The 5.7.1 event you're seeing is usually a permissions related issue on the ... SMTP virtual server. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.exchange.connectivity)
  • Re: new user cant access shared folders
    ... Users shouldn't be given rights or permissions unless absolutely necessary. ... You never stated whether NTFS is the file system, in which case security ...
    (microsoft.public.win2000.advanced_server)
  • Re: Determining query rights.
    ... Go to the view drop down and enable advanced features ... CCNA, MCSE + Security "WS" wrote in message ... >> domain using the effective rights tool. ... >> Read permissions are required, as per membership of the Pre-W2K>> compatible ...
    (microsoft.public.windows.server.active_directory)
  • Re: Shared Folder on Windows 2000 is ReadOnly from XP Home
    ... >> Did you set full permissions in both Sharing - Permissions, and in Security? ... >> combination of both Sharing (for network rights), ...
    (microsoft.public.windowsxp.network_web)