Roles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Roles

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    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
    There is always a better way to do the things.

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    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
    There is always a better way to do the things.

  3. #3
    Join Date
    Dec 2000
    Posts
    138
    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

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    Hi,

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

    Thanks,
    Badrinath
    There is always a better way to do the things.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width