DATABASE: for almost every DBA_* there is an ALL_* and a USER_*

DATABASE: for almost every DBA_* there is an ALL_* and a USER_*

In the database administration world, for each user, two types of records are kept - ALL (records which the user has permission to view) and USER (user's own records with access privileges). This ensures better security and accuracy in data processing.

Hence, for almost every DBA_* there is an ALL_* and a USER_* .

We just need to change USER, ALL, and DBA prefixes to get what we want.

So DBA_TABLES has all the tables the systems has, ALL_TABLES has all the tables the current user has permissions to do something on (update, delete, insert, modify, etc.), and USER_TABLES (all the tables the current user created).

Example:

select * from USER_USERS;
select * from DBA_USERS; 

That will display a column name "expiry_date" which has the data you ask for.

Moysekou

Waterloo, 21-MAR-2023 @11:57 am, BELGIUM

#database #technologies #tech #digital #oracle # intech #plsql #innovation