It sounds like you're on the right path. I'd suggest just breaking it down. First, find out who $USER is on the box that seems not to work correctly:
Let's say the response is 'bob'. Next, rather than using $USER, instead grep for 'bob':
Of course, you might not get anything, so you might want to check "last" manually and see if bob's on the list. If not, and you're logged in as bob, last would seem to be broken in some way. If so, grep is broken, which seems pretty unlikely. If grepping for bob works, but grepping for $USER doesn't, then the use of env variables is failing. Try one of these:
Hey guys,
I would like to find all files which contain "client1.dat". I would like to search from the current directory and all subs and print out all the files that have this. Any help would be greatly appreciated.
Thanks much. (10 Replies)
I have crated a file xx wth env redirected into it 5 times n couldnot proceed further
n next we have to create a script that takes 1 argument being a file, in this instance we use the newly created file above xx(xx file contains the env redirected into it 5 times) read the inputted file, in... (1 Reply)
When I typed in ps -a I get this:
PID TTY TIME CMD
31799 pts/3 00:00:00 vim
31866 pts/3 00:00:00 vim
And to check who is currently logged in, I type who
Felix Whoals
Tada Whoals
Lala Whoals
How can I get the user process for all current users who logged in?? I think I need to combine... (14 Replies)
Hello,
Neither ‘Grep -r' nor ‘grep -R' is working in my environment. (Searching for a text pattern in the files)
Any suggestions... Using SunOS 5.9
Thanks,
Trinanjan. (1 Reply)
Hey guys
I need a script that reads a login name and verifies if that user is currently logged in
i have found few commands like "who" and "users"
but i wonder how can i verify it that login name is logged in or not? (3 Replies)
Hi Every body,
I would need a shell script program to login as different user and perform some copy commands in the script.
example: Supppose ora_toms is the active user
ora_toms should be able to run a script where user: ftptomsp pass: XXX should login through and run the commands
... (9 Replies)
Hello,
I need to write one script which should search particular pattern like ABCD in log file name hello.txt only in current date logs.
in current directory i have so many past date logs but grep should be applied on current date logs.
on daily basis current date logs are in number 30 and... (2 Replies)
In any non-root account, whenever I enter mail, it gives me:
/var/spool/mail/root: Permission deniedI am not logged in as root, why is mail accessing root's mailbox ?
I am unable to enter the currently logged in user's mailbox.
Any help is appreciated :) (2 Replies)
Discussion started by: Hijanoqu
2 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)