Showing posts with label Users. Show all posts
Showing posts with label Users. Show all posts
Thursday, June 5, 2025

create user in postgres - basic syntax

›
I will create a group role called common_users a user called ro_user1 in a database called db01 The read-only user ro_user1 should ...
Tuesday, October 29, 2024

Lock and expire users

›
An anonymous PL/SQL block to lock and expire open accounts: SET VERIFY OFF connect "SYS"/"&&sysPassword" as SYS...
Wednesday, October 19, 2022

How to prevent a user from login into a postgres database

›
alter role scott with nologin; ALTER ROLE Remember that in postgres, "users" and "roles" are used interchangably, so...
Wednesday, September 4, 2019

How to create a proxy authenticated user in Oracle

›
Create a general user for authentication: CREATE USER APP_POOL IDENTIFIED BY app_pool_users123 DEFAULT TABLESPACE USERS TEMPORARY TABL...
Thursday, May 9, 2019

How to unlock users with expired password in postgreSQL

›
select now()+'90 days' as expiry; expiry ------------------------------- 2019-08-07 10:07:01.172082+02 \gset alter user jim valid...
Friday, December 7, 2018

How to create the SCOTT user

›
To create the user SCOTT, run the script $ORACLE_HOME/rdbms/admin/utlsampl.sql Observe that user SCOTT will be created with the following...
Thursday, October 18, 2018

What is the meaning of the "10G 11G 12C" value in DBA_USERS.PASSWORD_VERSIONS?

›
Since I wrote my post What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS? , Oracle 12c added yet another v...
5 comments:
Thursday, January 18, 2018

How to work around ORA-01017 in a migrated 12c database

›
You may see some users in your 12c database that have the password versions set to 10G: select username, password_versions from dba_user...
2 comments:
Wednesday, January 11, 2017

How to find users in the database with default passwords

›
select d.username,account_status from dba_users_with_defpwd d inner join dba_users u on d.username = u.username where u.account_status = ...
Sunday, December 18, 2016

How to create a common and a local user in a 12c multitenant database

›
In a multitenant container database, there are two types of users: * Common users, who are known in both the root containers and in all th...
Monday, December 12, 2016

How to find the last password change a user made

›
Limit the search to those users who changed their password today: select name,ctime "created", ptime "passw change time...
Tuesday, December 22, 2015

Generate "drop user" statement for schemas with and without objects

›
set lines 200 col owner format a20 col username format a30 col schema format a30 PROMPT ==================================================...
Tuesday, August 26, 2014

What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS?

›
When the value of DBA_USERS.PASSWORD_VERSIONS is shown as "10G 11G", it means that both old and new-style hash values are availabl...
Wednesday, November 27, 2013

How to write a procedure that lets developers set the time for the database using the FIXED_DATE procedure

›
The following procedure may be used to let designated database developers change the system time according to their testing needs. CREATE ...
Friday, November 15, 2013

How to temporarily alter a PROFILE

›
Temporarily disable the password verify function and set it back to the original value again when you're done: SQL> ALTER PROFILE D...