April 27, 2011 at 1:45 pm
Hi - Is it possible to hide the data in a column from a 3rd party reporting application? I cannot modify the schema or the report's format, but I can add database users and change permissions, roles, etc.
BTW - I tried limiting the reporting app's login permissions to only select objects, but the report then errors out.
April 27, 2011 at 1:53 pm
I thought you had to do it through a view...I'm not sure if there's another way.
Leonard
Madison, WI
April 27, 2011 at 1:55 pm
LM1 (4/27/2011)
I thought you had to do it through a view...I'm not sure if there's another way.
Yes, that was my first thought. But, I don't know how to incorporate that view in the a report that I cannot modify.
April 27, 2011 at 1:57 pm
I would think a view would be the cleanest way to go with this. Remove access to the base table, create the view omitting the column in question and simply grant permissions to the View alone.
April 27, 2011 at 2:01 pm
I would have thought the report would need to be changed anyway seeing as it will now be referencing a Column that no longer exists?
April 27, 2011 at 2:02 pm
OTF (4/27/2011)
I would think a view would be the cleanest way to go with this. Remove access to the base table, create the view omitting the column in question and simply grant permissions to the View alone.
But wouldn't this require modification on the reporting end? I cannot make any changes to what data the report is asking for.
April 27, 2011 at 10:08 pm
You can try this.
Create a view with same name as table name in differenct schema at databaselevel.
and then set this schema as default schema for the user .
This would make life easier if you can't modify anything at report level.
just a trick , may be it could help you..
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply