All Questions
6 questions
0
votes
1
answer
710
views
Granting select on syscat.schemata - DB2
I was wondering if it is safe to grant select rights to syscat.schemata to users on a DB2 database? What could go "wrong"?
Some tool like DataGrip and DBeaver cannot load connection schemas ...
- 163
2
votes
1
answer
5k
views
Has some command that lists the privileges of a user in db2?
I'm using db2 9.7 on linux and i want to list my privileges on database...
Ex: SYSADM, SECADM, DBADM, etc.
So, has some command in db2 that lists the privileges of a user in db2?
1
vote
1
answer
698
views
Auditing AS 400 DB2 library user access
As part of the testing to check for authorized users having access to applications and libraries on AS 400 systems, I need help to figure out a list of users having access to applications hosted on ...
- 11
4
votes
1
answer
19k
views
Create new Read Only user on DB2 on the whole database
I am an oracle/sql server DBA having limited knowledge in IBM DB2. We have DB2 9.7 fp4 running on AIX 6. I would like to create a new user and grant him READ only privilege on a particular database. ...
- 153
4
votes
1
answer
3k
views
Adding group rights in db2 for a stored procedure
I have a list of user accounts on AIX server, where the db2 database resides in. The user accounts all belong to a specific group which I can confirm from aix shell.
User accounts work in DB2. ...
- 141
1
vote
1
answer
799
views
db2 connecting to a db via alias and storing user name and password
I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
