Privileges require geodatabase lock?

Question

Original User: alnesbit

Hello all,

I'm trying to put privileges on a feature class in a 9.3 SDE sql server database. There are people connected to the data though and there are current edit sessions. Is the database locked so I can't put privileges on the feature classes? I keep getting error messages.

What ever happened to NIM032695 - Ability to grant or add layer privileges in ArcCatalog while a user is viewing the layer ?

http://forums.esri.com/Thread.asp?c=158&f=2284&t=262890&mc=12#msgid808280

Thanks,

SURVEY.JPG

TEST.JPG

MelissaNorthey · Answer

Have you tried the Change Privileges GP tool? It is under Toolboxes>System Toolboxes>Data Management Tools> Database.

Thanks!

Thank you so much for pointing that tool out!  Almost year later and I come across this today and found the Change Privileges GP tool to be my new best friend.  Funny, it worked where another add-on (ArcSDE User Priviliges) and the right-click Privileges failed.

Anonymous User · Answer

Original User: alnesbit

Hello all,

I have something even better!! Check this out! http://arcscripts.esri.com/details.asp?dbid=15123

Thanks to Jonathan at ESRI Tech Support for sending this my way.

Cheers,

RussellBrennan · Answer

The behavior that you are describing is as the software was designed. There are a number of workflows where we have to be careful to avoid getting the database into an inconsistent state. Granting privileges in cases where there are schema locks will not cause harm. However there are cases where revoking privileges could cause inconsistency and therefore we prevent revoke when there are schema locks.

In the next release of the software we are working on making it easier to identify these locks and where they are coming from. This should make it much easier to avoid this type of locking issue.