Question: create synonym d for prj_department; create synonym e for prj_employees; create synonym ep for prj_empproject; create synonym l for prj_locations; create synonym p for prj_project;

create synonym d

for prj_department;

create synonym e

for prj_employees;

create synonym ep

for prj_empproject;

create synonym l

for prj_locations;

create synonym p

for prj_project;

create synonym t

for prj_titles;

Question 5

Implement user access control for different objects

create user 'ytanabe2032' profile 'default'

identified by 'yto8nzi3' default tablespace 'db_data'

temporary tablespace 'temp_data'

account unlock;

Error at Command Line:4 Column:0

Error report:

SQL Error: ORA-01031: insufficient privileges

01031. 00000 - "insufficient privileges"

*Cause: An attempt was made to change the current username or password

without the appropriate privilege. This error also occurs if

attempting to install a database without the necessary operating

system privileges.

When Trusted Oracle is configure in DBMS MAC, this error may occur

if the user was granted the necessary privilege at a higher label

than the current login.

*Action: Ask the database administrator to perform the operation or grant

the required privileges.

For Trusted Oracle users getting this error although granted the

the appropriate privilege at a higher label, ask the database

administrator to regrant the privilege at the appropriate label.

What's wrong with this!!!!!!!!??????

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!