By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Tables and Columns security in database db2

P: 2
Hi all,

Currently, if someone has access to the database, they will be able to
view all the tables in the database.

We want to be able to set additional security for some other tables. So if
the person who has rights to access the database must require another
set of password in order to view the data in some table.

pls advise can security be set :
1) By tables.
2) By certain columns within the table. (E.g. in MT_EMPLOYEE_PY_RENUM
table, we have a column BASIC_SALARY, so only this column needs to have
added security.)

Thanking you

Regards
Narayan
Jun 29 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.