Roles

Hi,

I have the tables in JDE which have 'Grant all on public' previliges. Now I can to create a user with only the read permissions on the very same tables.

Will the roles override the permissions on the base table.

Badrinath

Hi,

I tried to do the following:

SCOTT:
Grant all on emp to public;
revoke all on emp from abc;

ABC:
select * from scott.emp;
Works...fine.

What did the "Revoke all on emp from abc" do ?

Badrinath

does nothing.

because the grants to public is still there.

if you want to implement that, do on a per user basis or use VPD if in 8i/9i.

HTH

Hi,

What is VPD! and how do I use it. I am on 8i

Thanks,
Badrinath