Q: Column Level Security

Hola!

I am working in a application in which we need to be able to enforce column level security dynamically. What I mean by dynamically is that we will be having a pool of modules that we need to assign to users depending on the user position, etc. The problem we have is due to the use of ODBC in some of our clients. We need to be able to restrict in some way access to the server or allow users to see just a selected information in the database. We need this because of some business rules that are enforced with our application.

One ideas was:

	Create roles with the specific privileges in the tables and using SET ROLE,
	select the role specific to our application.  The problem with this is that the
	role is granted to the user, so he can activate the role manually and
	have access to the tables.

Any others?

Thanks,
Juan Received on Fri Feb 24 1995 - 03:55:35 CET