I am trying to clone a schema and the grants on it, but when I try to clone it it will not copy the users or roles on the schema as well, how can I do that?
For example:
USE ROLE ACCOUNTADMIN (accountadmin is the owner of Test_db.schema)
CREATE Test_DB.SCHEMA_clone
CLONE Test_DB.SCHEMA
I did not see the same grants, so I had to add them after:
GRANT USAGE ON SCHEMA Test_DB.SCHEMA TO ROLE my_objectrole
Can I clone and copy the grant privileges from the cloned object?