/
How to transfer ownership of shared query folders?
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to transfer ownership of shared query folders?
Currently, a user is not allowed to edit the queries that are shared with him/her. It is not possible to transfer the ownership of the query folder to another user from the user interface. However, this can be achieved by executing the following SQLs.
For example, the ownership of the query folder 'Admin queries' needs to be transferred from the user 'Neha' to 'Shraddha'. Listed below are the commands that need to use.
select identifier from catissue_user where login_name = 'neha'; # Output: 23 select identifier from catissue_user where login_name = 'shraddha'; # Output: 24 update catissue_query_folders set owner = 24 where name in ('Admin queries'); # you can add more folder names to the IN clause separated by a comma.
, multiple selections available,
Related content
Share queries
Share queries
More like this
How to resolve permissible-values.xml changeset failed.
How to resolve permissible-values.xml changeset failed.
More like this
Query Privilege (v6.3)
Query Privilege (v6.3)
More like this
Cart Folders(v9.1)
Cart Folders(v9.1)
More like this
Export database from one tablespace and import into another
Export database from one tablespace and import into another
More like this
Database Console
Database Console
More like this
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com