Module user_db_management

Module user_db_management 

Source
Expand description

User and Database Management

This module provides comprehensive user and database management operations including:

  • List users and databases
  • Create/drop users and databases
  • Update user passwords
  • Role management
  • Granular permission management

Structs§

DatabaseInfo
PostgreSQL database information
UserInfo
PostgreSQL user information

Enums§

Privilege
PostgreSQL privilege types

Functions§

create_database_with_options
Create a database with options
create_role
Create a role (user without login)
create_user_with_options
Create a user with full options
database_exists
Check if a database exists
drop_database
Drop a database
drop_user
Drop a user
grant_privileges
Grant specific privileges on a database to a user
grant_role
Grant a role to a user
list_databases
List all databases in the PostgreSQL instance
list_users
List all users in the PostgreSQL instance
revoke_privileges
Revoke privileges on a database from a user
revoke_role
Revoke a role from a user
update_user_password
Update user password
user_exists
Check if a user exists