We're a community of 1077K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,076,285 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

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

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
1 Day
Discussion Span
1 Year Ago
Last Updated
2
Views
jacksantho
Junior Poster
169 posts since Feb 2011
Reputation Points: 7
Solved Threads: 0
Skill Endorsements: 0

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

pritaeas
Posting Prodigy
Moderator
9,310 posts since Jul 2006
Reputation Points: 1,178
Solved Threads: 1,465
Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0576 seconds using 2.67MB