How to check the lock status of any Linux user Account ?

 

If user Locked 

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# passwd -S postgres

postgres LK 2022-10-04 -1 -1 -1 -1 (Password locked.)

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]#

If user Unlocked

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]# passwd -S postgres

postgres PS 2022-10-04 -1 -1 -1 -1 (Password set, SHA512 crypt.)

[root@10.1.1.1 ~]#

[root@10.1.1.1 ~]#

========================

LK: Password locked

NP: No password

PS: Password set

"ORA-00942 : table or view does not exist. " on synonym

"ORA-00942- table or view does not exist" error you are getting , this indicate that user1 does not have privileges on the user.test table (get the details from synonyms SQL which tables are included ) .

We need to grant that required privileges 

SQL> GRANT SELECT, INSERT, UPDATE, DELETE 

     ON USER.TEST 

     TO USER1;

Note : Create dynamic sql to refersh the privelige if multiple tables and schema included 

How to chnage the global name of a database in AWS oracle RDS ?

 

We have to login as admin user 

exceute below commands 

EXEC rdsadmin.rdsadmin_util.rename_global_name(p_new_global_name => 'new_global_name');

What is Git ?

 

• Git is created by Linus Torvalds in 2005

• Git is the distributed version control system. This stored all version properly  and documented very well 

• Git has ability to track of changes to content and provide mechanisms for sharing the content with other in team

• This is open-source and free software

• Available for multiple platforms (Linux, Unix, Mac, Windows )

• Active community and more than 70%  developer used