ALTER USER(7) SQL Commands ALTER USER(7)NAME
ALTER USER - change a database role
SYNOPSIS
ALTER USER name [ [ WITH ] option [ ... ] ]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEUSER | NOCREATEUSER
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
ALTER USER name RENAME TO newname
ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER USER name SET configuration_parameter FROM CURRENT
ALTER USER name RESET configuration_parameter
ALTER USER name RESET ALL
DESCRIPTION
ALTER USER is now an alias for ALTER ROLE [alter_role(7)].
COMPATIBILITY
The ALTER USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
SEE ALSO
ALTER ROLE [alter_role(7)]
SQL - Language Statements 2010-05-14 ALTER USER(7)
Check Out this Related Man Page
ALTER DATABASE(7) SQL Commands ALTER DATABASE(7)NAME
ALTER DATABASE - change a database
SYNOPSIS
ALTER DATABASE name SET variable { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET variable
DESCRIPTION
ALTER DATABASE is used to change the session default of a run-time configuration variable for a PostgreSQL database. Whenever a new session
is subsequently started in that database, the specified value becomes the session default value. The database-specific default overrides
whatever setting is present in postgresql.conf or has been received from the postmaster.
Only a superuser or the database owner can change the session defaults for a database.
PARAMETERS
name The name of the database whose session defaults are to be altered.
variable
value Set the session default for this database of the specified configuration variable to the given value. If value is DEFAULT or, equiv-
alently, RESET is used, the database-specific variable setting is removed and the system-wide default setting will be inherited in
new sessions. Use RESET ALL to clear all settings.
See SET [set(7)] and the Administrator's Guide for more information about allowed variable names and values.
DIAGNOSTICS
ALTER DATABASE
Message returned if the alteration was successful.
ERROR: database "dbname" does not exist
Error message returned if the specified database is not known to the system.
NOTES
Using ALTER USER [alter_user(7)], it is also possible to tie a session default to a specific user rather than a database. User-specific
settings override database-specific ones if there is a conflict.
EXAMPLES
To disable index scans by default in the database test:
ALTER DATABASE test SET enable_indexscan TO off;
COMPATIBILITY
The ALTER DATABASE statement is a PostgreSQL extension.
SEE ALSO
ALTER USER [alter_user(7)], CREATE DATABASE [create_database(l)], DROP DATABASE [drop_database(l)], SET [set(l)]
SQL - Language Statements 2002-11-22 ALTER DATABASE(7)
Hi,
I am a junior dba and started carrier very new. I have a batch file to create some script of db creation. I want that batch file to convert in .sh file so that I can directly run that in the AIX box to generate those files.
Please help me with the code for AIX. Batch file is here:
... (2 Replies)
Hello All,
I'm trying to put together a shell script that will:
1. connect to an oracle database
2. execute a query
3. save the output to a csv file
I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text... (9 Replies)
Hi Experts,
I am trying to write a shell script to change DB user password.
Requirement:
login to multiple DBs as multiple users and change their respective passwords.
ex :users:T1,T2,T3
DB:X,Y,Z
scenario:
login as T1 to X,Y,Z
change password
login as T2 to X,Y,Z
change password
... (2 Replies)
Hello Everyone,
I have developed a shell script which takes schema id and password as parameter to login into database using sqlplus,runs a query and mails the result.
My requirement is that, I dont want to pass userid and password as parameters.Instead,I want to pass say Environment... (4 Replies)
Hi,
I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password.
Could you please provide the script for this task?
Steps are given below.
1. Login into database from server
sqlplus... (5 Replies)
Good afternoon all!! I am writing a shell script that will generate a random phrase to be used as a password.
this is the line I use to generate the password
echo `head -n 10 /dev/urandom | tr -cd "*+,-/:;<=>?_" | cut -c '1-'$3`
The third input in the command is the length of the password i... (6 Replies)
Hi all,
I have a script like this, where i am trying to login into oracle db via ssh and do a account unlock.
#!/bin/sh
ip=$1
os_user=$2
key=$3
ou_user=$4
ou_pass=$5
unlock_user=$6
ssh -i $key $os_user@$ip
sudo -u $ou_user -p $ou_pass -- i am getting error here...its not taking... (16 Replies)
Hi,
OS: Redhat 7.5
shell: Bash
Wrote below script to login into oracle via shell script and trying to reset locked account..It works as expected. But I need specific output << EOF should go to target terminal not all out put
running below script from ansible command line..
#!/bin/bash... (1 Reply)