07-21-2010
User Privilege
How to assign superuser privilege to an ordinary user temporarily
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Is it possible to grant write privileges to a user on a directory with out having to add the user to a group or make the user the owner of the directory?
My background is in Windows and in Windows you can grant specific privileges to a user without having to put the user in a group or making the... (3 Replies)
Discussion started by: here2learn
3 Replies
2. AIX
I'm trying to give a non-root user the right to start IBM HTTP Server, the web server is listening on port 80, but for AIX, ports under 1024 are privilege ports which can be used only by root.
/usr/IBMIHS/bin# ./apachectl start
(13)Permission denied: make_sock: could not bind to address :::80... (1 Reply)
Discussion started by: ibmer414
1 Replies
3. Solaris
Can anyone please tell how to give root privilege to a normal user in solaris 10? (5 Replies)
Discussion started by: nicktrix
5 Replies
4. UNIX for Dummies Questions & Answers
Hello experts I am new to Unix.
Env : HPUX
I need to create a user say testuser such that it does not have access to file/directories from the other group i.e the last 3 digits .
How do I do that.
Reason for such a request :-
I have an existing user oracle which has default umask... (3 Replies)
Discussion started by: simonsimon
3 Replies
5. Solaris
OS Version: Sun Solaris version 9
Other than root, we need operation to manage printer queue by using following command:
lprm -P
cancel
enable/disable
What privilege should be given?
Pls advise.
Thank you. (4 Replies)
Discussion started by: KhawHL
4 Replies
6. UNIX for Dummies Questions & Answers
what does x(in rwx) privilege mean?
just text files or shell script files?
that's so confusing. (3 Replies)
Discussion started by: kang
3 Replies
7. AIX
I am planning to implement sudo for users.
Under , it looks I have to put the users who need to have sudo access:
What are the recommended for users? I don't think I need to give the ALL privilege (i.e ) to AIX users.
I'd like to know the commonly used privilege specification for sudo... (9 Replies)
Discussion started by: Daniel Gate
9 Replies
8. Cybersecurity
I am planning to implement sudo for users.
Under , it looks I have to put the users who need to have sudo access:
What are the recommended for users? I don't think I need to give the ALL privilege (i.e ) to AIX users.
I'd like to know the commonly used privilege specification for sudo... (1 Reply)
Discussion started by: Daniel Gate
1 Replies
9. Shell Programming and Scripting
Hi ,
I want to create 3 different user with below privilege in Solaris and Linux.
1) Read Only
2)Read and Write Only
3) Admin user
Can you guys help me on this . (3 Replies)
Discussion started by: Naveen Pathak
3 Replies
10. Solaris
Hi
I need to assign proc_owner privilege to particular user through RBAC. How can I assign this privilege to user, I need help on this.
Further I need to understand if I give this proc_owner privilege to particular user, what kind of control user will get on other user or system processes... (7 Replies)
Discussion started by: sb200
7 Replies
LEARN ABOUT CENTOS
set_session_authorization
SET SESSION
AUTHORIZATION(7) PostgreSQL 9.2.7 Documentation SET SESSION AUTHORIZATION(7)
NAME
SET_SESSION_AUTHORIZATION - set the session user identifier and the current user identifier of the current session
SYNOPSIS
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name
SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT
RESET SESSION AUTHORIZATION
DESCRIPTION
This command sets the session user identifier and the current user identifier of the current SQL session to be user_name. The user name can
be written as either an identifier or a string literal. Using this command, it is possible, for example, to temporarily become an
unprivileged user and later switch back to being a superuser.
The session user identifier is initially set to be the (possibly authenticated) user name provided by the client. The current user
identifier is normally equal to the session user identifier, but might change temporarily in the context of SECURITY DEFINER functions and
similar mechanisms; it can also be changed by SET ROLE (SET_ROLE(7)). The current user identifier is relevant for permission checking.
The session user identifier can be changed only if the initial session user (the authenticated user) had the superuser privilege.
Otherwise, the command is accepted only if it specifies the authenticated user name.
The SESSION and LOCAL modifiers act the same as for the regular SET(7) command.
The DEFAULT and RESET forms reset the session and current user identifiers to be the originally authenticated user name. These forms can be
executed by any user.
NOTES
SET SESSION AUTHORIZATION cannot be used within a SECURITY DEFINER function.
EXAMPLES
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
peter | peter
SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
session_user | current_user
--------------+--------------
paul | paul
COMPATIBILITY
The SQL standard allows some other expressions to appear in place of the literal user_name, but these options are not important in
practice. PostgreSQL allows identifier syntax ("username"), which SQL does not. SQL does not allow this command during a transaction;
PostgreSQL does not make this restriction because there is no reason to. The SESSION and LOCAL modifiers are a PostgreSQL extension, as is
the RESET syntax.
The privileges necessary to execute this command are left implementation-defined by the standard.
SEE ALSO
SET ROLE (SET_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 SET SESSION AUTHORIZATION(7)