Article ID: 115783, created on Mar 21, 2013, last review on Jun 17, 2016

  • Applies to:
  • Plesk 12.0 for Linux


It is possible to create user which can manage all databases on given subscription since Plesk 11.5 (see release notes for preview release).

However, quick switch between databases in DB Webadmin (phpMyAdmin) would be not available, as phpMyAdmin is always opened for a specific database.

In versions prior to 11.5, permissions to manage additional databases should be granted manually.

Important: manually granted permissions will not be registered by Plesk, which means that user will not appear in control panel. It also means that such permissions will not be saved in backup or migrated by Plesk.

To grant database user permissions to manage another database, use these instructions:

  • MySQL: following SQL statements should be executed:

    >GRANT ALL PRIVILEGES ON <newdb>.* TO 'olduser'@'%';
  • PostgreSQL: login to template1 database, grant all privileges on database to user and add user into a group with the same name as database:

    # su - postgres
    $ psql template1
    template1=# grant all privileges on database newdb to olduser;
    template1=# grant newdb to olduser;
    template1=# \dg
                       List of roles
     Role name |  Attributes  |            Member of
     olduser   |              | {olddb,newdb}
  • MSSQL: open SQL Server Management Studio (free download from Microsoft website for SQL Server 2005, 2008 and 2012). Connect to SQL server, in Object Explorer (left frame) expand Security → Logins, right-click on required database user and select Properties. In user properties, go to User Mapping, check new database and at the bottom select db_owner role and apply settings:

Search Words





grant permission

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 29d1e90fd304f01e6420fbe60f66f838 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF