Jdbc

[Ishaibin]

If I have an application that can access tables , but i want to block some of the columns in certain tables , so lets say if i have 4 columns : name, address, phone, email , only the name and email will be displayed .
how can i achive that ?

[stephen_wee]

Hi
Are you asking about JDBC or are you asking about selecting the respective columns from a table?

If it is the latter, just add the columns that you wish to extract the values from in the SQL statement:

Select name, email from table

[Ishaibin]

ofcourse ,
but this is the spesific case.
My question is if there is a way that some columns within a table will be marked as accessable only to authorized .
so if my software tries to acess it , and the company doesnt want, it cant.
is that possible ?

[ArchAngel]

Depends on the specific database you're using, but most database system will allow you to GRANT different USER accounts access to different tables, fields etc.

Check the DDL of the tables.

[Ishaibin]

Can you explain me abit more ?
and what are the JDBC classes that handles it ?
so i could read the documentation .

[ArchAngel]

It's not to do with JDBC - it's to do with the definition of the tables themselves using SQL. You need to read the documentation supplied with your database. For example, if you are using MySQL:

http://www.mysql.com/doc/en/GRANT.html