June 24, 2002 at 6:13 am
Hi
All system and user objects in one db on our product server were denied automatically . I mean no one can access to these tables, views, sps,... except SA.
any suggestions will be appreciated.
June 24, 2002 at 6:19 am
Double check the db_denyreader and db_denywriter roles, may have everyone in those.
Andy
June 24, 2002 at 10:55 pm
Hi,
tanx Andy for ur reply.I create a new db and a login for it and put this user as db_denyreader & db_denywriter but when i check object's permissions everything was ok and no object's permisson were denied. and the main problem is WHY ALL OBJECT WERE DENID AUTOMATICALLY!
June 25, 2002 at 4:10 am
The objects themselves may not have the permission applied if the user objects have restrictions. db_denyreader & db_denywriter roles automatically prevent access. Another possible place is did anyone change the setting of the public role?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 25, 2002 at 10:12 pm
This is the imporatant point four me I want to know who did this changes to the db. I mean how can I AUDIT changes in dbs, Ofcourse I activate it by choosing Audit Level in server properties but I can't find any log about changing these setting like : deleting table or changing permission ,... by even DBO .
Do u have any idea about it?
SaNaZ
June 26, 2002 at 9:35 am
You would need some type of third party tool or run Profiler. I do not believe that you can set an alert for this.
Of course, you should have VERY few people with the ability to do this, so you can handle that administratively.
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply