Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I was trying to revoke access for a user using Python script, but it does not seem to work.
I mean the script runs successfully without any error, but does not what it's intended to...

Here're the steps I follow:

  1. I am connecting with the schema owner, and revoking access for another user, say 'B' for a particular dataset [Python]
  2. The script runs OK...without any error (exits with code 0)
  3. Connect with user B to chk if it's worked...and NO, I can see the data still

Any idea why its hapeening?
I've tried with exclusive lock; and ArcCatalog...even then the same result :(

Ujjwal

share|improve this question

1 Answer 1

up vote 1 down vote accepted

OK...I think I have a possible reason for the privileges not being applied.

In a special case of REVOKING ACCESS (my case!), you need to have exclusive lock on the schema. So if other users are still connected, you won't be able to revoke access to a FC or DATASET.

But shouldn't the tool fail (as it does with other functions like Create FeatureClass in similar scenario)...? Design question...may be.

I will update the result after obtaining exclusive lock...currently many users connected to my database.

Cheers!
UPDATE: If the GDB access is governed by ROLES at the database level, it would take precedence during privilege modification via script or ArcCatalog...the solution would be using the role names while granting/revoking access.

share|improve this answer
    
UPDATE: Revoke does not work even after granting exclusive access i.e. killing all other sessions to the particular schema! I've tried with Python script; using ArcCatalog, but both of them have the same result...NOTHING! Any guesses why such a behaviour? –  ujjwalesri Dec 20 '11 at 2:02
    
UPDATE 2: Installed ArcGIS 10 SP3, "just in case" it is a patching issue....but no, it is still the same!!! x-( –  ujjwalesri Dec 20 '11 at 3:20
1  
UPDATE 3: I think I have the answer now...if the GDB access is governed by ROLES at the database level, it would take precedence to the privilege modification via script or ArcCatalog...the solution would be modifying the role to achieve the result! –  ujjwalesri Dec 20 '11 at 3:49
    
Please consider editing your answer to include the solution you arrived at and of course you can (and should) accept your own answer! –  blah238 Apr 12 '12 at 8:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.