Member Avatar for jacksantho

Hi,

1. Just am created a user for the login 'test'.
2. As with this login 'test', i logined to the server.
3. I don't have the permission to create the database.
4. So i tried this query:

use master
          grant create any database to user
          go

5. Am facing this following error: why ?

Msg 4613, Level 16, State 1, Line 2
          Grantor does not have GRANT permission.

6. please help me out. Thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 3K Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

The user you created did not get permission to GRANT permissions to other users. Login as sysdba and try the GRANT query again.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.