Unanswered: authentication for db and stored procedures
In our DB2 v7.2 server database working in AIX, we had a user USER1(let's say) in the group which has the dbadmin privileges on the database.
Now I have to restrict the priviliges of USER1, such that he can only *create tables,views,indexes
*select/update/insert/delete tables(but not of the SYSCAT,SYSIBM or SYSSTAT)
*execute,create,change stored procedures(java stored procedures and sql procedures) that have been created.
-I have created another group that has no privileges, remove USER1 from dbadmin group and add him to this group.
-I have granted the user bindadd,connect, createtab,load on this database.
-I have granted "all privileges" on tables whose schemas are not SYSIBM,SYSCAT or SYSSTAT.
My questions are:
? I did not grant select on tables owned by SYSIBM,SYSCAT or SYSSTAT.Will it cause any problem when USER1 wants to run the restricted priviliges above(marked with *)?
? I don't know the commands to authenticate USER1 for the stored procedure part above.Can you also help me with this?
? Do i need to make any additional grants?