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

Thread: grant role with default mode

  1. #1
    Join Date
    Dec 2000
    Posts
    15

    Thumbs down

    Hi !!!, i need to give access of roles but i have any questions ?

    create role teste;

    grant teste to final_user;

    but role it´s not default role for some users, it 's occurr because i need alter all users;

    alter user final_user default role all;


    Thanks
    sslobo@globo.com
    Sandro Lobo
    Oracle DBA
    www.geocities.com/sslobopt

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Oracle does not support granting default role while creating a user.
    You need to grant separately.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    When ever you define the role, you could grant access to that at the time of user creation or alter user time or grant. You use the grant mostly to give restricted access in specific. On the other hand if you enclose in the user level, it would be one of his default permission setups. I hope this would give you an idea.

    Sam

  4. #4
    Join Date
    Dec 2000
    Posts
    15

    Thumbs up Thanks !!!!

    Thanks !!!!!!!!!!!!!!
    I understand !!!!

    Thanks very much !!!

    [QUOTE][i]Originally posted by sambavan [/i]
    [B]When ever you define the role, you could grant access to that at the time of user creation or alter user time or grant. You use the grant mostly to give restricted access in specific. On the other hand if you enclose in the user level, it would be one of his default permission setups. I hope this would give you an idea.

    Sam [/B][/QUOTE]
    Sandro Lobo
    Oracle DBA
    www.geocities.com/sslobopt

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