SAMIZDAT-ROLE(1) General Commands Manual SAMIZDAT-ROLE(1)NAME
samizdat-role - Samizdat role management
SYNOPSIS
samizdat-role [ OPTIONS ] --list
samizdat-role [ OPTIONS ] --grant MEMBER
samizdat-role [ OPTIONS ] --revoke MEMBER
DESCRIPTION
samizdat-role Allows to view, grant, and revoke member access to priviledged roles on a Samizdat site.
OPTIONS --site SITE
Name of the Samizdat site (overrides SAMIZDAT_SITE environment variable).
--role ROLE
Name of a role, default is moderator.
--grant MEMBER
Grant ROLE priviledges to MEMBER. MEMBER may be specified as resource id or login name.
NB: To grant or revoke priviledges using this command, you must use database superuser priviledges (in PostgreSQL, this is 'postgres').
--revoke MEMBER
Revoke ROLE priviledges from MEMBER. MEMBER may be specified as resource id or login name.
NB: To grant or revoke priviledges using this command, you must use database superuser priviledges (in PostgreSQL, this is 'postgres').
EXAMPLE
su postgres -c 'samizdat-role --site s1 --grant joe --role moderator --list'
Grant moderator priviledges to the member 'joe' of site 's1' and list all moderators.
AUTHOR
This manual page was written by Dmitry Borodaenko <angdraug@debian.org>. Permission is granted to copy, distribute and/or modify this doc-
ument under the terms of the GNU GPL version 3 or later.
SAMIZDAT-ROLE(1)
Check Out this Related Man Page
DROP ROLE(7) PostgreSQL 9.2.7 Documentation DROP ROLE(7)NAME
DROP_ROLE - remove a database role
SYNOPSIS
DROP ROLE [ IF EXISTS ] name [, ...]
DESCRIPTION
DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must
have CREATEROLE privilege.
A role cannot be removed if it is still referenced in any database of the cluster; an error will be raised if so. Before dropping the role,
you must drop all the objects it owns (or reassign their ownership) and revoke any privileges the role has been granted. The REASSIGN OWNED
(REASSIGN_OWNED(7)) and DROP OWNED (DROP_OWNED(7)) commands can be useful for this purpose.
However, it is not necessary to remove role memberships involving the role; DROP ROLE automatically revokes any memberships of the target
role in other roles, and of other roles in the target role. The other roles are not dropped nor otherwise affected.
PARAMETERS
IF EXISTS
Do not throw an error if the role does not exist. A notice is issued in this case.
name
The name of the role to remove.
NOTES
PostgreSQL includes a program dropuser(1) that has the same functionality as this command (in fact, it calls this command) but can be run
from the command shell.
EXAMPLES
To drop a role:
DROP ROLE jonathan;
COMPATIBILITY
The SQL standard defines DROP ROLE, but it allows only one role to be dropped at a time, and it specifies different privilege requirements
than PostgreSQL uses.
SEE ALSO
CREATE ROLE (CREATE_ROLE(7)), ALTER ROLE (ALTER_ROLE(7)), SET ROLE (SET_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 DROP ROLE(7)
:) i have made new title for myself since i am very serious about unix I thought that it might reflect this a little and also help me to gain some more self esteem to be more dillegent in my questions and answers to others.. I have an avatar but I am not quite sure how to apply it. if any moderator... (5 Replies)
Discussion started by: moxxx68
5 Replies
3. Post Here to Contact Site Administrators and Moderators
Hi there! I liked your forum so much! I'm a professional moderator and I would like to moderate your forum or any part of it. If you are interested in this idea, please apply to me on my e-mail. (5 Replies)
hi all,
a have problem to load *.txt to postgres
my database:
id_list_ip (nextval)
list_ip (varchar)
txt file (list_ip.txt)
hasilping_10.8.248.1
hasilping_119.110.112.226
hasilping_119.110.125.33
hasilping_125.22.1.25
hasilping_192.168.2.1
hasilping_202.73.96.70
script... (3 Replies)
Hi Admins,
As per my knowledge there are two types of user accounts in unix. root and normal users.
If there are any user types for which we can give some priviledges..?
Actually i want to restrict root access and create new accounts for admins with some of the priviledges.
Please let me... (6 Replies)
Hello All,
I need your help in getting a command. I have a input file as below:
"A0C0VN","XZ70720","02","MEMBER ELIGIBILITY_DC",2012021308,"",,,20120213
I need a command to remove the field in Bold. To be specific the 5th field along with the next comma (2012021308,) needs to be taken... (6 Replies)
Discussion started by: Praveenkulkarni
6 Replies
7. Post Here to Contact Site Administrators and Moderators
Hello moderator, i've tried to watch the video tutorial, cause i'd like to use this forum by the right way, but it was imposible, i just can see the comment of other persons about it, anything else.
What am i to do about it?
Thanks (3 Replies)
Please advise i need to change a text in a file, what should i do....
original text
18011324 ; serial number YYMMDDNN
m.abcd.com. 600 IN A 10.10.128.154
text need to replaced
18011325 ; serial number YYMMDDNN
m.abcd.com. 600 ... (10 Replies)
I appreciate the fact that rules are for everyone and I screwed up by not putting a screen printout in code brackets...
However, I was a bit dismayed when I received the following and tried to reply to say "Thank you" for sending me the reminder. I could not reply and had no idea what the... (4 Replies)
Discussion started by: RogerBaran
4 Replies
10. Post Here to Contact Site Administrators and Moderators
Hello MODs/Admins,
Could you please help me here as from last 6 to 7 days I(and checked with my fellow friends too) am not able to access unix.com site at all. It is very very slow, it never loads completely. Even I checked with different people and different computers it results same only,... (8 Replies)
Discussion started by: RavinderSingh13
8 Replies
11. Post Here to Contact Site Administrators and Moderators
Hi, Just wanting to know if there is any issues today with the site. Initially I thought it is my internet connection or computer but regardless which one I use, the site has been slow and it is also not showing with the right fonts etc. I've been trying for the last 12+ hours and it's always been... (21 Replies)