Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View all users

Status
Not open for further replies.
oana12

oana12

Programmer
Jan 6, 2005
21
0
0
CA
Hi,

Please help me with these questions:
1. Which are equivalents views in DB2 for ALL_USER and ALL_TAB_PRIVS from Oracle?
2. Can I used EXECUTE IMMEDIATE in DB2 to create dynamic, in a procedure, a user and then to grant privileges to this user?

P.S I am new in DB2 so I appreciate your help.

Thanks.
 
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question
hi all, input TAB1 COL1
Replies
0
Views
46
gdg1976
gdg1976
msol25
  • Locked
  • Question
Please help me to get all users list in DB2
Replies
2
Views
117
bwleon
bwleon
msol25
  • Locked
  • Question
Please help for query list all tables in DB2 using squirrel tool
Replies
0
Views
46
msol25
msol25
evr72
  • Locked
  • Question
DB2 SQL View Editable Fields
Replies
0
Views
28
evr72
evr72
Motlatjo
  • Locked
  • Question
Hi All I would like to know if i
Replies
2
Views
41
Motlatjo
Motlatjo

Part and Inventory Search

Sponsor

Back
Top