RE: Users on a DB are dropped without any intervention
From: Donna Lambert [MS] (dlambert@online.microsoft.com)
Date: 08/13/02
- Next message: Donna Lambert [MS]: "Re: SA PW"
- Previous message: Larry Woods: "Re: Newbie: Why don't I have Security on one of my drives?"
- In reply to: pat: "Users on a DB are dropped without any intervention"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: dlambert@online.microsoft.com (Donna Lambert [MS]) Date: Tue, 13 Aug 2002 14:33:10 GMT
Pat,
Do you have periodic restores of this database from perhaps a production
server? Or from a development server? That would explain the scenario you
are seeing. And yes, as the previous poster said, it could be that someone
is dropping the object and recreating it (perhaps a snapshot replication
type scenario), and the rights aren't being propagated properly.
Donna Lambert
Microsoft SQL Server Support
Disclaimer:
This posting is provided “AS IS” with no warranties, and confers no rights.
Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Recent viruses on the Internet underscore the threat to all computer users
and highlight challenges facing the entire industry in providing security
that everyone needs to conduct business. I encourage you to sign up to
receive automatic notification of Microsoft Security Bulletins by visiting
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
bulletin/notify.asp. For more information on security, our Strategic
Technology Protection Program and to order your FREE Security Tool Kit,
please visit http://www.microsoft.com/security. We will be happy to answer
any questions or provide assistance with your security needs.
--------------------
| Content-Class: urn:content-classes:message
| From: "pat" <pwfitzgerald@hotmail.com>
| Sender: "pat" <pwfitzgerald@hotmail.com>
| Subject: Users on a DB are dropped without any intervention
| Date: Tue, 30 Jul 2002 06:56:25 -0700
| Lines: 16
| Message-ID: <2f3401c237d0$e5489660$3bef2ecf@TKMSFTNGXA10>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcI30OVI9U7AnY3RQn+LfgHwCT8pCg==
| Newsgroups: microsoft.public.sqlserver.security
| Path: cpmsftngxa06
| Xref: cpmsftngxa06 microsoft.public.sqlserver.security:7277
| NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| 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
|
- Next message: Donna Lambert [MS]: "Re: SA PW"
- Previous message: Larry Woods: "Re: Newbie: Why don't I have Security on one of my drives?"
- In reply to: pat: "Users on a DB are dropped without any intervention"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
