[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Oracle 10g - creating roles

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
joaotelles
Asked:
joaotelles
  • 6
  • 4
3 Solutions
 
sdstuberCommented:
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
 
sdstuberCommented:
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
 
joaotellesAuthor Commented:
Tks for the fast reply.

Its more like a password that would expire in 6-10 hours, is it possible?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
joaotellesAuthor Commented:
Tks sdstuber.
0
 
sdstuberCommented:
to create a 6 hour password lifetime (values are in days) ...


CREATE PROFILE your_profile_name LIMIT   PASSWORD_LIFE_TIME .25;

0
 
joaotellesAuthor Commented:
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
 
sdstuberCommented:
to assign your new profile to some user....


alter user SOME_USER profile YOUR_PROFILE_NAME;
0
 
sdstuberCommented:
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
 
sdstuberCommented:
or comma delimited


grant YOUR_ROLE_NAME to bobje, bomdb;
0
 
joaotellesAuthor Commented:
Tks!
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now