467,887 Members | 1,586 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

Tables and Columns security in database db2

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

Jun 29 '07 #1
  • viewed: 864

Post your reply

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

Similar topics

18 posts views Thread by Ken Kazinski | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.