QUESTION POSED ON: 15 October 2008
I have a file F4211 in a library prod. This file contains a large amount of company data.
In order to implement security, I created a view F4211 in another library staging in the following way:
CREATE VIEW STAGING.F4211 AS SELECT * FROM PROD.F4211 WHERE SDKCOO='12345'
I granted access to a user for this view but the user says he is facing problems with the privilege error when he attempts to access the view.
Could you please let me know if I need to grant access to F4211 in prod library also? However, if I do that there will be a loophole, as the user will be able to access all data.
One last thing to mention is that the user does not have any privileges on prod library. I would like to fix this user's problem with the priviledge error without enabling this user to access all data.
|
