-
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
-
Oracle does not support granting default role while creating a user.
You need to grant separately.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|