Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Object Permissions Lost Expand / Collapse
Author
Message
Posted Sunday, February 27, 2011 9:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 25, 2011 8:18 PM
Points: 39, Visits: 186
Hi,

I detached a database, moved it to another bigger disk, attached it back, executed the change_users_login. This is a replicated database. -- so before above steps, i drop all the subscriptions, and publications for this database.

The next day, I received reports from developers and users that the permissions to objects like SELECT, DELETE, INSERT, UPDATE, EXECUTE are gone they are receiving error from their applications.
They had problems with lost permissions from other databases as well in that same instance which I did not do any maintenance.

I believe that object permissions will not disappear or remove when detaching a database.
Thank God I have a backup of the previous objectpermissions script and just executed it.

What possible could have happen?

Thank you,
ZaiZai
Post #1070299
Posted Tuesday, March 1, 2011 1:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 1:37 AM
Points: 1, Visits: 23
read this : http://tonythetester.blogspot.com/2008/08/unable-to-open-physical-file.html
Post #1071026
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse