12-10-2009
Looked more closely at the original post. Could multiple matches with text in the password file.
Preferable syntax makes an exact match on the username.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Thanks PxT answered my "compare two files"question very quick and neat!!:-)
I have a question about .history file I couldn't find any satisfied answer from book.
1. This file was created automatically when you set up user's environment or you have to use a command to create it or you... (4 Replies)
Discussion started by: b5fnpct
4 Replies
2. UNIX for Dummies Questions & Answers
is there a way to show information on all the users on your system? when i use 'finger' is only shows users names and info who are currently on the system. is there a way to show all accounts? thanx! (5 Replies)
Discussion started by: djatwork
5 Replies
3. UNIX for Dummies Questions & Answers
hi, .sh_history keeps a list of past commands that we entered. but it has a limit and where do we set this limit. thanks. (1 Reply)
Discussion started by: yls177
1 Replies
4. UNIX for Advanced & Expert Users
Hi Friends,
We are currently 5 people using same Unix login-id on different terminals, .sh_history file contains list of commands typed by all 5 peoples(commands history) with the below list :
$tail .sh_history
ls -ltr
pwd
cd ..
ls -ltr
clear
cd temp
more kk.lst
Now my question... (9 Replies)
Discussion started by: krishna
9 Replies
5. UNIX for Dummies Questions & Answers
All,
I had a request to delete filed under a directory that was 35 days old . And they asked me to scedule it in CRON . I have done that .
I have use find and delete with mtime to perfrom this task .
But my script is not deleting this .cshrc,.exrc,.login,.profile,.sh_history file... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
6. AIX
hi
what's the difference between .sh_history and sh_history for root user?
thanks
itik (1 Reply)
Discussion started by: itik
1 Replies
7. AIX
Hello Everyone:
Does anyone know how I will setup my account to put timestamp in my .sh_history? I do not hold the root account. I am using AIX 5 and ksh shell. I tried every solution I can find in the internet but nothing seems to work OR I am just applying those in the wrong way. Anyone knows... (4 Replies)
Discussion started by: Orbix
4 Replies
8. AIX
I reviewed a couple old post where shockneck posted the use of the EXTENDED_HISTORY=ON variable to place a timestamp in the .sh_history file when using ksh and using the fc -t command to read the .sh_history file.
The fc command reads my history file. As an admin I would like to be able to read... (5 Replies)
Discussion started by: juredd1
5 Replies
9. UNIX for Advanced & Expert Users
Hi,
I'm on a linux machine. But I see that sh_history is not updated since february 15. How is it possible ?
Thank you.
uname -a
Linux MYSERVER 2.6.18-194.11.3.el5PAE #1 SMP Mon Aug 23 15:57:10 EDT 2010 i686 i686 i386 GNU/Linux
ls -al
-rw------- 1 oracle dba 3644 fév 15 09:28... (10 Replies)
Discussion started by: big123456
10 Replies
10. AIX
Hi,
I can't get all the enties of AIX .sh_history in email. only first entry of the history is emailed after executing the below code.
mail -s "History `date +%d-%m-%Y`" myemail@xyz.com <$HOME/.sh_history
Can anyone help? (3 Replies)
Discussion started by: m_raheelahmed
3 Replies
LEARN ABOUT SUSE
alter_user_mapping
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)