Users on a DB are dropped without any intervention

From: pat (pwfitzgerald@hotmail.com)
Date: 07/30/02 

From: "pat" <pwfitzgerald@hotmail.com>
Date: Tue, 30 Jul 2002 06:56:25 -0700

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: Users on a DB are dropped without any intervention
    ... This posting is provided “AS IS” with no warranties, and confers no rights. ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | rights in a couple of the databases that they had rights ...
    (microsoft.public.sqlserver.security)
  • Re: Users on a DB are dropped without any intervention
    ... re-establishing the permissions for all the users. ... to upgrade a stored proc that the user has rights to execute with a DROP ... > rights in a couple of the databases that they had rights ... I haven't touched their security ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Proc rights and joinning to another database
    ... If the databases and tables has the same owner, ... As of sp3, ... I have a little problem with one of my Stored Proc. ... rights to my users on tables but I give execute rights on my Stored ...
    (microsoft.public.sqlserver.server)
  • Re: Revoking public permissions
    ... We have many databases with all rights to user tables, views, stored ... (I have never tried to revoke public rights to the ... the public role in the system databases. ...
    (microsoft.public.sqlserver.security)
  • Lost User rights / permissions
    ... I have 2 login accounts that infrequently lose all of ... their permissions and rights to databases and stored ... has read access to 2 databases, ... rights against a stored procedure. ...
    (microsoft.public.sqlserver.security)