Home  • Database • IBM DB2
Can any one help me with IBM DB2 data base ???how can i privilege my default user db2admin with sysIBM ??its really urgent........plzzz

Comments 7


Soon you will get the answer. enjoy . send your photo to first replay.
db2 CONNECT TO MYDB; SET SCHEMA DB2ADMIN; db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE TO USER DB2ADMIN; CONNECT RESET;
i use this query sir bt it gives me a error
Before using this command you have to login as admin
ami db2admin ei user die login korchi bt i don't konw my system user er password so i can't login with my sys
All the user privilege related command must be provided by system admin.
Why you don't know system user password? Who install IBM DB2 to your PC?
About Author
Shakila Jannat
Copyright © 2024. Powered by Intellect Software Ltd