Python script to set privileges / add users to Enterprise Geodatabase

TylerT

Hello,

Does somebody have a sample Python script they could share that adds users to Enterprise Geodatabase tables?  I am looking for the scripted analogy of this GUI workflow...(right click on EGDB table)

...of all or list of tables in the Enterprise Geodatabase.

Thank you,

Tyler

HerveHabonimana

After struggling with this issue, here is how I resolved it in Oracle Database

 

 

# this script assign SELECT, INSERT, UPDATE, DELETE 
import arcpy, os, oracledb
dbuser    = 'dbuser' # the user who needs access
# path to sde
path = r'path to .sde'
# path to connection file
sde_path = os.path.join(path, f'file.sde')
USER = "sde level username"
PASSWORD = "psw"
DSN = "dns"
oracledb.init_oracle_client(lib_dir=None)
conn = oracledb.connect(user=USER, password=PASSWORD, dsn=DSN)
curs = conn.cursor()
writer_role_name = f"the name of the role you want to assign to user"
db_name = "the name of the schema"
# assign the writer role to the user

arcpy.CreateRole_management(sde_path, writer_role_name,
                            "GRANT", dbuser)
feature_lists = ['fc1', 'fc2']
for fc in feature_lists:
    fc_ = f"{db_name}.{fc}"
    print(fc_)
    try:
        print(f"Granting privileges to {writer_role_name} on {fc_}...")
        curs.execute(f"GRANT SELECT, INSERT, UPDATE, DELETE ON {fc_} TO {writer_role_name}")
        conn.commit()
        print(f"Privileges granted to {writer_role_name} on {fc_}")
    except Exception as e:
        print(f"Failed to grant privileges to {writer_role_name} on {fc_}")
        print(e)