Grantor Question

Aug 27, 2006

I use SQL Server 2005.
I log in using windows authentication.

When I grant alter any database to server securable the grantor is sa,
while when I grant connect to certain endpoint the grantor is the windows account by which I log in.

Why is the grantor different in every case?

Thank you.
Bishoy

View 1 Replies


ADVERTISEMENT

Grantor Does Not Have GRANT Permission.

Apr 12, 2008

I run the following query...using sql analyzer dbo.aCVChangeSQLPassword 'user1','user1',''I am logged in as user1 in the sql analyzer...It chnages my password, in sql server, however gives me this message...Grantor does not have GRANT permission.Password changed.(1 row(s) affected)Server: Msg 4613, Level 16, State 1, Procedure aCVChangeSQLPassword, Line 27Grantor does not have GRANT permission.
Line no 27 has the folliwng code that I execute...
 
exec sp_password @old,@new,null
 

View 1 Replies View Related

Grantor Does Not Grant Permission

Jun 18, 2008

Hi I have installed Sql server 2005.  I tried to give "Create database" permission to master database I am getting an errorGrantor does not grant permission (Microsoft SQL Server, Error 4613) May  I know what is the reason for this.How to resolve it. RegardsKaran 

View 1 Replies View Related

Error: Grantor Does Not Have Grant Permission

Jan 4, 2006

Hi all,Before using SQL Server 2000 Developer Edition I did not get this error message. I had been using the trial edition of SQL Server 2000.I only get it with stored procedures.I solved my problem by giving the ASPNET login "db_owner" privs, which I didn't need to with the trial edition and is not best practice from a security angle.I login under the Windows based admin account. (not using mixed mode).Hope someone can shed some light.Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved