Hard part is done.
Now become the instance owner ( or dbadm or secadm depending on how your
security is configured ) and grant the user connect on the database and any
other useful things they need ( like, maybe, select on a table or two).
If the user will actually be logging on to the Linux guest and making the
queries from the command line, then you need to add this line into the
users .profile :
/<db2 instance home directory>/sqllib/db2profile
this will insure that all of the DB2 "stuff" is defined to the user session
Oh - welcome to my world since the description "our Mainframe DBA's who
have had DB2 LUW thrust upon them" fits me some few years ago.
Tony Saul
<generalemaillist
[email protected]> To
Sent by: Linux on [email protected]
390 Port cc
<[email protected]
IST.EDU> Subject
Really dumb basic zLinux DB2 LUW
question
08/17/2011 06:57
PM
Please respond to
Linux on 390 Port
<[email protected]
IST.EDU>
This is from our Mainframe DBA's who have had DB2 LUW thrust upon them.
-----------------------
I am new to zLinux and DB2 LUW. I have to create a user and give them
select permissions to various tables.
I believe I need to do a
useradd -G <db2 group> username -p password
So I have done that no problems.
How to get that username known to DB2 LUW, so that the user can connect and
do their SELECT queries?
(Told you it was basic!).
--------------------------------------
Regards,
Tony
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO LINUX-390 or
visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
----------------------------------------------------------------------
For more information on Linux on System z, visit
http://wiki.linuxvm.org/
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
----------------------------------------------------------------------
For more information on Linux on System z, visit
http://wiki.linuxvm.org/
