1,105,375 Community Members

How to fix this error 'Grantor does not have GRANT permission' ?

Member Avatar
jacksantho
Junior Poster
169 posts since Feb 2011
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

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

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article