We have implemented both data roles and user roles in Aster. I wanted to create some way to make it easy for users to apply the proper grants to their tables when they're ready to allow others access to the tables. Generally, I'd write a procedure that takes in the schema name and table name and would dynamically create and execute something like:
grant all on <schema name>.<table name> to dr_<schema name>_rw;
grant select on <schema name>.<table name> to dr_<schema name>_ro;
I see Aster doesn't have a concept of stored procedures. Is there some way I'm not aware of that will make it easy for users to provide grants to their tables in line with our standards or are we stuck with providing the above instructions and trusting the users to implement correctly?
You can use executables option in AMC, build your script and schedule it as per your requirement.