Anyone can explain how should a user be aliased ( please explain command ).
If aliased can we limit the permission compared to original user to aliased user ?

Thanks in Advance.

If my understanding of your question is correct, then , you cannot alias a user afaik

Please explain with an example ...

Cheers
Sathyaram

OK.
suppose you are a 'db2inst1' user with syadm/dbadm previledges and a new user 'mytask' wants to use all the object created by 'db2inst1' so if you alias 'mytask' to 'db2inst1'.

If you want to access objects in a schema other than one matching the connected ID, you can either:

--specify the objecte with db2inst1.TABNAME

--issue "db2 set schema db2inst1" This lasts for the duration of your session or until you change it.

--create aliases for each object:
create alias mytask.tabname for db2inst1.tabname

you can create alias for user like below


db2 -x " select ' create alias mytask.'||rtrim(name)||' for '||rtrim(creator)||'.'||ltrim(name) ||';' from sysibm.systables where creator = 'DB2INST1' " > crtalias.sql


db2 -tvf crtalias.sql -z crtalias.log



that will generate DDL for create alias & create alias


hope it may help you


Thank You


Lekharaju Ennam
Certified Oracle & DB2 UDB DBA