Database Object Permissions Lost

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Database Object Permissions Lost

Database Object Permissions Lost

Rate Topic

Display Mode

Topic Options

Author

Message

zaizaisql

Posted Sunday, February 27, 2011 9:13 PM

SSC 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

bernard.baeten

Posted Tuesday, March 01, 2011 1:38 AM

Forum 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 »

Permissions