It might affect applications. If the user owns some directories or files on the server, then you will have to manually fix ownership on them, as after the change they will be owned by the old UID.
Hi guys,
In the UNIX work environment we have access other peoples directory and sometimes we have full
access to other people's files.
How can we find out , other than modification time that WHO did modification on any file ?
I know we can change the access of any file by chmod but... (0 Replies)
Hi to all,
Need help! For user sysoper on oracle, I want to know who and on which date/time the password has been modified? The platform is unix itself.
Thanks (2 Replies)
Please anyone can tell me what is the procedure to perform the required modifications in configuration files to disable a particular user??? (3 Replies)
How to restrict modification of a file while it is already in use by another user?
If a file is in use by one user account, how to restrict it so that no one else can change it until its closed by the first user? (3 Replies)
Hi, I'm executing a script to check if a file has been modified on a shared folder.
I use this to start another script every time the file has been modified.
To do this I use the 'ls' command to get the last modification date of the file.
My problem is that the computer hosting the shared... (5 Replies)
I need help modifying the code below.
DATAFILE is a log file.
I have two strings i need to search for in the log file.
The two strings are:
1. ERROR
2. com.rolander.promotions.client
awk 'BEGIN {
while((getline < "'${SFILE}'")>0)
S
FS="\n"; RS="\n"
} (11 Replies)
I have below code, i want to run this code, but this below code should run on
myblocka
myblockb
myblockcc
myblockxx
myblockanything
but it will not run on "myblock"
for BLOCK in /sys/block/myblock*
do
echo "100000" > "$BLOCK"/abcd
done (7 Replies)
Referring back to this thread:
Tapatalk Modification for vB3 - Issue with Avatar Icons
I mentioned that we had some "system bot" code:
In this post, I describe that code and how easy it is to create a "system bot" user for Tapatalk (TT):
Basically, its quite easy. We add a hook to... (0 Replies)
How do a user login with full user-environment preset to Bash shell then automatically do path modification with few script codes, either on command-line or put it in a script file.
what i tried:
bash --login -c PATH="/ANewPath:${PATH}"
bash --login -c 'PATH="/ANewPath:${PATH}"; export PATH'... (2 Replies)
I'm usia Raspbian, a Debian subset, and wondering what work would be involved in altering the cp command.
cp at present needs a full path and file name for source and at least full filename for destination. How can I change this so the second parameter isn't needed? So if the destination... (6 Replies)
Discussion started by: MuntyScrunt
6 Replies
LEARN ABOUT CENTOS
reassign_owned
REASSIGN OWNED(7) PostgreSQL 9.2.7 Documentation REASSIGN OWNED(7)NAME
REASSIGN_OWNED - change the ownership of database objects owned by a database role
SYNOPSIS
REASSIGN OWNED BY old_role [, ...] TO new_role
DESCRIPTION
REASSIGN OWNED instructs the system to change the ownership of the database objects owned by one of the old_roles, to new_role.
PARAMETERS
old_role
The name of a role. The ownership of all the objects in the current database owned by this role will be reassigned to new_role.
new_role
The name of the role that will be made the new owner of the affected objects.
NOTES
REASSIGN OWNED is often used to prepare for the removal of one or more roles. Because REASSIGN OWNED only affects the objects in the
current database, it is usually necessary to execute this command in each database that contains objects owned by a role that is to be
removed.
REASSIGN OWNED requires privileges on both the source role(s) and the target role.
The DROP OWNED (DROP_OWNED(7)) command is an alternative that drops all the database objects owned by one or more roles. Note also that
DROP OWNED requires privileges only on the source role(s).
The REASSIGN OWNED command does not affect the privileges granted to the old_roles in objects that are not owned by them. Use DROP OWNED to
revoke those privileges.
The REASSIGN OWNED command does not affect the ownership of any databases owned by the role. Use ALTER DATABASE (ALTER_DATABASE(7)) to
reassign that ownership.
COMPATIBILITY
The REASSIGN OWNED statement is a PostgreSQL extension.
SEE ALSO
DROP OWNED (DROP_OWNED(7)), DROP ROLE (DROP_ROLE(7)), ALTER DATABASE (ALTER_DATABASE(7))
PostgreSQL 9.2.7 2014-02-17 REASSIGN OWNED(7)