Description
This function revokes all privileges for a PostgreSQL® database from a database user.
Examples
cPanel or Webmail Session URL
https://hostname.example.com:2083/cpsess##########/execute/Postgresql/revoke_all_privileges?user=example_dbuser&database=example_database
LiveAPI PHP Class
$cpanel = new CPANEL();
$grant_all = $cpanel->uapi(
'Postgresql', 'revoke_all_privileges',
array(
'user' => 'example_dbuser',
'database'=> 'example_database',
)
);
LiveAPI Perl Module
my $cpliveapi = Cpanel::LiveAPI->new();
my $grant_all = $cpliveapi->uapi(
'Postgresql', 'revoke_all_privileges',
{
'user' => 'example_dbuser',
'database'=> 'example_database',
}
);
cPanel Template Toolkit
[% data = execute( 'Postgresql', 'revoke_all_privileges', { user => 'example_dbuser', database => 'example_database'} ); %]
Command Line
uapi --user=username Postgresql revoke_all_privileges user=example_dbuser database=example_database
|
Output (JSON)
{
"messages": null,
"errors": null,
"status": 1,
"metadata": {
},
"data": null
}
Parameters
|
Parameter
|
Type
|
Description
|
Possible values
|
Example
|
|
name
|
string
|
Required
The database user's name.
|
A valid string.
Note:
If database prefixing is enabled, this value must include the database prefix for the account.
|
example_dbuser
|
|
database
|
string
|
Required
The database's name.
|
A valid string.
Note:
If database prefixing is enabled, this value must include the database prefix for the account.
|
example_database
|
Returns
This function only returns metadata.
