Microsoft Windows [Version 10.0.19045.
3208]
(c) Microsoft Corporation. All rights reserved.
C:\Users\Ashar Javed>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:13:19 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:15:34 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: talha
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> create table abc (sn int);
Table created.
SQL> create view a as
2 select sn
3 from abc;
View created.
SQL> select * from a;
no rows selected
SQL> insert into abc (sn)values(34);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from a;
SN
----------
34
SQL> drop view a;
View dropped.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:25:25 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> grant create any table to a;
Grant succeeded.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:29:12 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: talha
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select * from admins;
select * from admins
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from sys.admins;
select * from sys.admins
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:31:01 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> grant select on sys.admins to talha;
Grant succeeded.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:32:21 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: talha
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: talha
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select * from sys.admins;
NAME
--------------------------------------------------------------------------------
usman
usman
usman
aaaa
ali
SQL> insert into sys.admins (name)values('aaaa');
insert into sys.admins (name)values('aaaa')
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:34:25 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> grant insert,update,delete on sys.admins to talha;
Grant succeeded.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:35:07 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: talha
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> insert into sys.admins (name)values('aaaa');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from sys.admins;
NAME
--------------------------------------------------------------------------------
usman
usman
usman
aaaa
ali
aaaa
6 rows selected.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:36:34 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> revoke update on sys.admins from talha;
Revoke succeeded.
SQL> quit
Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
Production
C:\Users\Ashar Javed>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 16 18:37:12 2023
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: talha
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> des user_sys_prvis;
SP2-0734: unknown command beginning "des user_s..." - rest of line ignored.
SQL> des user_sys_privs;
SP2-0734: unknown command beginning "des user_s..." - rest of line ignored.
SQL> desc users_sys_privs;
ERROR:
ORA-04043: object users_sys_privs does not exist
SQL> desc user_sys_privs;
Name Null? Type
----------------------------------------- -------- ----------------------------
USERNAME VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
SQL> select username,privilege,admin_option from user_sys_privs;
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
PUBLIC CREATE SESSION NO
TALHA DROP ANY CUBE BUILD PROCESS NO
TALHA SELECT ANY CUBE NO
TALHA CREATE MINING MODEL NO
TALHA DROP ANY ASSEMBLY NO
TALHA CREATE EXTERNAL JOB NO
TALHA CREATE ANY JOB NO
TALHA CREATE JOB NO
TALHA GRANT ANY OBJECT PRIVILEGE NO
TALHA ADMINISTER RESOURCE MANAGER NO
TALHA ALTER ANY TYPE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA DROP ANY MATERIALIZED VIEW NO
TALHA DROP ANY PROCEDURE NO
TALHA ALTER ANY PROCEDURE NO
TALHA CREATE PROCEDURE NO
TALHA ALTER DATABASE NO
TALHA CREATE ANY SYNONYM NO
TALHA CREATE CLUSTER NO
TALHA CREATE ANY TABLE NO
TALHA CREATE TABLE NO
TALHA MANAGE TABLESPACE NO
TALHA CREATE SESSION NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA AUDIT SYSTEM NO
TALHA DELETE ANY MEASURE FOLDER NO
TALHA CREATE ANY MEASURE FOLDER NO
TALHA SELECT ANY MINING MODEL NO
TALHA CREATE ANY MINING MODEL NO
TALHA ALTER ANY ASSEMBLY NO
TALHA ALTER ANY EDITION NO
TALHA DROP ANY EDITION NO
TALHA ADMINISTER ANY SQL TUNING SET NO
TALHA ADVISOR NO
TALHA EXECUTE ANY RULE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA EXECUTE ANY RULE SET NO
TALHA CREATE ANY EVALUATION CONTEXT NO
TALHA DEBUG ANY PROCEDURE NO
TALHA RESUMABLE NO
TALHA ON COMMIT REFRESH NO
TALHA DROP ANY CONTEXT NO
TALHA EXECUTE ANY INDEXTYPE NO
TALHA CREATE ANY INDEXTYPE NO
TALHA CREATE INDEXTYPE NO
TALHA CREATE OPERATOR NO
TALHA ALTER ANY LIBRARY NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA UNDER ANY TYPE NO
TALHA DROP ANY TRIGGER NO
TALHA ALTER ANY TRIGGER NO
TALHA DROP ANY CLUSTER NO
TALHA SELECT ANY TABLE NO
TALHA DROP TABLESPACE NO
TALHA UPDATE ANY CUBE BUILD PROCESS NO
TALHA CREATE CUBE NO
TALHA SELECT ANY CUBE DIMENSION NO
TALHA EXECUTE ASSEMBLY NO
TALHA CREATE ANY EDITION NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA MANAGE ANY FILE GROUP NO
TALHA FLASHBACK ANY TABLE NO
TALHA ENQUEUE ANY QUEUE NO
TALHA ALTER ANY OPERATOR NO
TALHA CREATE ANY LIBRARY NO
TALHA ALTER ANY MATERIALIZED VIEW NO
TALHA CREATE ANY MATERIALIZED VIEW NO
TALHA DROP ANY VIEW NO
TALHA DROP PUBLIC SYNONYM NO
TALHA CREATE SYNONYM NO
TALHA ALTER ANY CLUSTER NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA ALTER ANY TABLE NO
TALHA CREATE USER NO
TALHA CREATE ANY CUBE BUILD PROCESS NO
TALHA DROP ANY CUBE NO
TALHA CREATE ANY CUBE NO
TALHA DROP ANY CUBE DIMENSION NO
TALHA CREATE ANY CUBE DIMENSION NO
TALHA ALTER ANY CUBE DIMENSION NO
TALHA CREATE ANY ASSEMBLY NO
TALHA EXECUTE ANY CLASS NO
TALHA CREATE RULE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA DROP ANY RULE SET NO
TALHA CREATE ANY RULE SET NO
TALHA CREATE RULE SET NO
TALHA DROP ANY EVALUATION CONTEXT NO
TALHA MERGE ANY VIEW NO
TALHA ADMINISTER DATABASE TRIGGER NO
TALHA MANAGE ANY QUEUE NO
TALHA EXECUTE ANY OPERATOR NO
TALHA CREATE ANY OPERATOR NO
TALHA CREATE ANY TYPE NO
TALHA ALTER RESOURCE COST NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA DROP PROFILE NO
TALHA ALTER PROFILE NO
TALHA DROP ANY ROLE NO
TALHA DROP PUBLIC DATABASE LINK NO
TALHA CREATE PUBLIC DATABASE LINK NO
TALHA CREATE VIEW NO
TALHA CREATE PUBLIC SYNONYM NO
TALHA ALTER ANY INDEX NO
TALHA DELETE ANY TABLE NO
TALHA INSERT ANY TABLE NO
TALHA ALTER ROLLBACK SEGMENT NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CREATE MEASURE FOLDER NO
TALHA ALTER ANY CUBE NO
TALHA ALTER ANY MINING MODEL NO
TALHA DROP ANY MINING MODEL NO
TALHA MANAGE FILE GROUP NO
TALHA DROP ANY SQL PROFILE NO
TALHA EXECUTE ANY PROGRAM NO
TALHA CREATE EVALUATION CONTEXT NO
TALHA CREATE ANY OUTLINE NO
TALHA DEQUEUE ANY QUEUE NO
TALHA QUERY REWRITE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA ALTER ANY INDEXTYPE NO
TALHA DROP ANY LIBRARY NO
TALHA EXECUTE ANY TYPE NO
TALHA DROP ANY DIRECTORY NO
TALHA CREATE MATERIALIZED VIEW NO
TALHA GRANT ANY PRIVILEGE NO
TALHA ANALYZE ANY NO
TALHA CREATE ANY TRIGGER NO
TALHA CREATE TRIGGER NO
TALHA AUDIT ANY NO
TALHA DROP ANY SEQUENCE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CREATE ANY VIEW NO
TALHA DROP ANY INDEX NO
TALHA ALTER SYSTEM NO
PUBLIC CREATE TABLE NO
TALHA ADMINISTER SQL MANAGEMENT OBJECT NO
TALHA UPDATE ANY CUBE DIMENSION NO
TALHA INSERT ANY MEASURE FOLDER NO
TALHA INSERT ANY CUBE DIMENSION NO
TALHA COMMENT ANY MINING MODEL NO
TALHA READ ANY FILE GROUP NO
TALHA ADMINISTER SQL TUNING SET NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CREATE ANY RULE NO
TALHA ALTER ANY EVALUATION CONTEXT NO
TALHA DEBUG CONNECT SESSION NO
TALHA ALTER ANY OUTLINE NO
TALHA UNDER ANY TABLE NO
TALHA GLOBAL QUERY REWRITE NO
TALHA EXECUTE ANY LIBRARY NO
TALHA EXECUTE ANY PROCEDURE NO
TALHA ALTER ANY ROLE NO
TALHA GRANT ANY ROLE NO
TALHA SELECT ANY SEQUENCE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA ALTER ANY SEQUENCE NO
TALHA CREATE SEQUENCE NO
TALHA UPDATE ANY TABLE NO
TALHA COMMENT ANY TABLE NO
TALHA CREATE ROLLBACK SEGMENT NO
TALHA DROP USER NO
TALHA CREATE TABLESPACE NO
TALHA RESTRICTED SESSION NO
TALHA ALTER SESSION NO
TALHA FLASHBACK ARCHIVE ADMINISTER NO
TALHA CREATE CUBE BUILD PROCESS NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA DELETE ANY CUBE DIMENSION NO
TALHA CREATE ASSEMBLY NO
TALHA CREATE ANY SQL PROFILE NO
TALHA DROP ANY RULE NO
TALHA EXPORT FULL DATABASE NO
TALHA EXECUTE ANY EVALUATION CONTEXT NO
TALHA DROP ANY OUTLINE NO
TALHA CREATE ANY DIMENSION NO
TALHA CREATE DIMENSION NO
TALHA UNDER ANY VIEW NO
TALHA DROP ANY INDEXTYPE NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CREATE ANY PROCEDURE NO
TALHA FORCE TRANSACTION NO
TALHA CREATE ANY INDEX NO
TALHA LOCK ANY TABLE NO
TALHA DROP ANY TABLE NO
TALHA DROP ROLLBACK SEGMENT NO
TALHA ALTER TABLESPACE NO
TALHA DROP ANY MEASURE FOLDER NO
TALHA UPDATE ANY CUBE NO
TALHA CREATE CUBE DIMENSION NO
TALHA EXECUTE ANY ASSEMBLY NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CHANGE NOTIFICATION NO
TALHA ALTER ANY SQL PROFILE NO
TALHA SELECT ANY TRANSACTION NO
TALHA MANAGE SCHEDULER NO
TALHA ALTER ANY RULE NO
TALHA IMPORT FULL DATABASE NO
TALHA ALTER ANY RULE SET NO
TALHA CREATE ANY CONTEXT NO
TALHA DROP ANY DIMENSION NO
TALHA ALTER ANY DIMENSION NO
TALHA DROP ANY OPERATOR NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA CREATE LIBRARY NO
TALHA DROP ANY TYPE NO
TALHA CREATE TYPE NO
TALHA CREATE ANY DIRECTORY NO
TALHA CREATE PROFILE NO
TALHA FORCE ANY TRANSACTION NO
TALHA CREATE ROLE NO
TALHA CREATE DATABASE LINK NO
TALHA CREATE ANY SEQUENCE NO
TALHA DROP ANY SYNONYM NO
TALHA CREATE ANY CLUSTER NO
USERNAME PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
TALHA BACKUP ANY TABLE NO
TALHA ALTER USER NO
TALHA BECOME USER NO
TALHA UNLIMITED TABLESPACE NO
202 rows selected.
SQL> desc user_sys_privs;^C
C:\Users\Ashar Javed>
C:\Users\Ashar Javed>
