user privilege to access schema ?
671943Mar 4 2009 — edited Mar 4 2009Hello All,
how can we give single schema access to multiple users ???????
I know the way to give privileges in the form roles and assign to different users ......
but in that case when other user access the tables , they have to use the owner.tablename to perform query.
my intention is when many authorized users acesses the tables , they could access just by giving table names ???????????????
is that possible ???