Grant access on tables

Prem Prakash · New User Joined: 07 Jan 2006 Posts: 6 Location: India

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.

With Regards,
Prem Prakash

ragshere · Active User Joined: 20 Dec 2004 Posts: 68

Hi Prem,

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.

Hope you got me.

Regards
Rags

Prem Prakash · New User Joined: 07 Jan 2006 Posts: 6 Location: India

Thanks a lot Rags.