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 USER MAPPING(7) SQL Commands ALTER USER MAPPING(7)NAME
ALTER USER MAPPING - change the definition of a user mapping
SYNOPSIS
ALTER USER MAPPING FOR { username | USER | CURRENT_USER | PUBLIC }
SERVER servername
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
DESCRIPTION
ALTER USER MAPPING changes the definition of a user mapping.
The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user mapping for his own user
name if USAGE privilege on the server has been granted to the user.
PARAMETERS
username
User name of the mapping. CURRENT_USER and USER match the name of the current user. PUBLIC is used to match all present and future
user names in the system.
servername
Server name of the user mapping.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the user mapping. The new options override any previously specified options. ADD, SET, and DROP specify the
action to be performed. ADD is assumed if no operation is explicitly specified. Option names must be unique; options are also vali-
dated by the server's foreign-data wrapper.
EXAMPLES
Change the password for user mapping bob, server foo:
ALTER USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'public');
COMPATIBILITY
ALTER USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED). There is a subtle syntax issue: The standard omits the FOR key word. Since both
CREATE USER MAPPING and DROP USER MAPPING use FOR in analogous positions, and IBM DB2 (being the other major SQL/MED implementation) also
requires it for ALTER USER MAPPING, PostgreSQL diverges from the standard here in the interest of consistency and interoperability.
SEE ALSO
CREATE USER MAPPING [create_user_mapping(7)], DROP USER MAPPING [drop_user_mapping(7)]
SQL - Language Statements 2010-05-14 ALTER USER MAPPING(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)