Sometime
DBA want to grant all system and object level permission to someone else in
single command. If it is test database
then fine but if it is production then you might be opening a big security
whole and should avoid this.
·
Login
as SYSTEM and Run Below SQL to check Privilege’s
o
select * from
system_privilege_map where name like '%PRIV%';
·
Create
a new user
o
create user mybasicknowledge
identified by mybasicknowledge123;
·
Grant
Create Session, System and Object privilege
o
grant create
session, grant any privilege, grant any object privilege to mybasicknowledge