ODA

[Maria Miller]

Is anyone using ODA to allow a user to only view certain tables? OW security does not allow us to lock a user out of a table. We could lock the user out of every column in the table but this is very tedious. Any suggestions?

Maria

 

[KSmithCPA]

Maria,

I've been thinking about it and there should be an option for "Object" security where you can restrict a users ability to View. Like I said, I don't have OW in front of me today, but that should allow you to lock down a table.

You can certainly add a layer of Data Base security to lock a group of users out of certain tables. You would need to create anothe generic database user for this second group.

Hope this helps.