Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Grant access on tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Prem Prakash

New User


Joined: 07 Jan 2006
Posts: 6
Location: India

PostPosted: Mon Apr 10, 2006 8:47 am    Post subject: Grant access on tables
Reply with quote

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
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Mon Apr 10, 2006 12:59 pm    Post subject: Re: Grant access on tables
Reply with quote

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
Back to top
View user's profile Send private message
Prem Prakash

New User


Joined: 07 Jan 2006
Posts: 6
Location: India

PostPosted: Mon Apr 10, 2006 2:46 pm    Post subject:
Reply with quote

Thanks a lot Rags.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm
No new posts ERM-Diagram of SysIBM-Catalog-Tables Auryn DB2 2 Fri Feb 17, 2017 6:22 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us