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
Get step-by-step solutions from verified subject matter experts
