?
Solved

Oracle 10g - creating roles

Posted on 2011-03-21
10
Medium Priority
?
483 Views
Last Modified: 2012-05-11
Hi I would like to know how to:

1-
create a new database role and grant dbms_crypto to this role
and then:
grant this role to the following database users: bobje, bomdb, dpownera, dpownera_1a

I don't know exactly how to grant dbms_crypto to this new role.

2-
set a temporary system password

Tks,
Joao Telles
0
Comment
Question by:joaotelles
  • 6
  • 4
10 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 35183920
dbms_crypto is owned by sys,  so you will need to be SYS to do the grant

log in as sys   (sqlplus / as sysdba)

grant execute on SYS.DBMS_CRYPTO to YOUR_ROLE_NAME;


DBA privilege or similar heightend privilege isn't enough


there is no such thing as a temporary password.
You can have a password that will expire,  is that what you mean?
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 1000 total points
ID: 35183929
if you do mean an expiring password,  you do that with profiles

either alter the DEFAULT,  or better yet,  create a new profile and alter its password rules then assign that profile to SYSTEM or other users
0
 

Author Comment

by:joaotelles
ID: 35183939
Tks for the fast reply.

Its more like a password that would expire in 6-10 hours, is it possible?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

Author Comment

by:joaotelles
ID: 35183942
Tks sdstuber.
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35183978
to create a 6 hour password lifetime (values are in days) ...


CREATE PROFILE your_profile_name LIMIT   PASSWORD_LIFE_TIME .25;

0
 

Author Comment

by:joaotelles
ID: 35183987
Also after
grant execute on SYS.DBMS_CRYPTO to YOUR_ROLE_NAME;

Then to grant this role to the following database users: bobje, bomdb, dpownera, dpownera_1a, would it be something similar with the AUTHORIZATION  statement right?

Tks,
Joao
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35183990
to assign your new profile to some user....


alter user SOME_USER profile YOUR_PROFILE_NAME;
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 35184002
no, you then grant the role to the users...

one grant per user...


grant YOUR_ROLE_NAME to bobje;
grant YOUR_ROLE_NAME to bomdb;

0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 1000 total points
ID: 35184007
or comma delimited


grant YOUR_ROLE_NAME to bobje, bomdb;
0
 

Author Closing Comment

by:joaotelles
ID: 35184015
Tks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question