Hi all,
For my inhouse project,i am acting as a DBA.i have created some tables using my mainframe login id.As we had to follow some standards so while creating tables i used AIS as prefix to table names(AIS.Table_name). Now i am unable to Grant access on these tables to other ids.its showing authorization error. but if i create a table without any prefix then i can Grant the access on tables to other ids. Please tell me how to grant access on tables having some prefix on the table names? Thanks.
To give the access on such tables, you should set the SQLID to that owner. In this case you have to execute below statement before granting the access.
SET CURRENT SQLID='AIS';
You can not run the above statement unless you have SYSADM authority or you connected to AIS racf group.
If you try to create the tables without any prefix , then those tables will be created under yourid. so you are the owner of the table. you can give any access to anyone on such tables.
