GRANT ALTER ANY LOGIN to my user

Pml 1 Reputation point
2020-12-23T23:25:38.653+00:00

Hi,

I need to grant ALTER ANY LOGIN to my "admin" user just created from Azure SQL Server.
This admin user seen to not be complet admin user in the new database.

The query "GRANT ALTER ANY LOGIN TO <myadminuser> give me this error:
Failed to execute query. Error: Securable class 'server' not supported in this version of SQL Server.

There is any possibility to create new FULL admin user or GRANT any permission on a database on Azure SQL Sever ?

Thanks

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,886 Reputation points MVP
    2020-12-24T05:56:05.457+00:00

    Hey,
    Follow the below steps for a SQL Account:

    Execute the below query on master database
    create login [login] with password = ‘<<>>’
    create user [login] from login [login]
    exec sp_addrolemember 'dbmanager', 'login'
    exec sp_addrolemember 'loginmanager', 'login'

    Then create the same user in the individual database and make it as db_Owner by:
    create user [login] from login [login]
    exec sp_addrolemember 'db_Owner', 'login'

    1 person found this answer helpful.
    0 comments
  2. Pml 1 Reputation point
    2020-12-24T08:59:02.057+00:00

    Hi,

    Thanks for your help,

    But it look like my new user don't have full "login" permissions:

    Look here what I need:

    db_owner
    "Database Owner"
    Required For: 

    Managing daily database operations
Altering database settings 
Upgrading database schema
Backup database
Performing database necessary

    public
    "Public Access"

    Required for: 

    Viewing database
Connecting to the database necessary

    Along with these roles, the account needs to have the "Alter any Login" Securable for the SQL server.

    There is a possibility to get the "Alter any Logon" Securable ?

    0 comments