create synonym d for prj_department; create synonym e for prj_employees; create

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 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!!!!!!!!??????

Explanation / Answer

the issue is

the user(session user or the username by which you are connected to DB ) you are using to create the user named ' ytanabe2032' doesn't have access to create user

to give the permission for creating user execute the below command with DBA user or role

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.