Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Grantor Does Not Have GRANT Permission.


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 27
Grantor does not have GRANT permission.

Line no 27 has the folliwng code that I execute...

 

exec sp_password @old,@new,null

 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Grantor Does Not Grant Permission
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 Replies !   View Related
Error: &"grantor Does Not Have Grant Permission&"
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 Replies !   View Related
Grant Permission
I want to Grant permission for a table which is residing at another server's database. I have added the server as a linked server to my database and i am able to do all DML (Insert, Update, Delete) operations from the source server to the target server's table. But i am not able to Grant permission for the table.

View Replies !   View Related
Grant Permission
how to grant alter table and set identity insert column permission in sql server 2005,

help is apprecitate

View Replies !   View Related
What Permission Do I Need To Grant ?
hello,



what permission do I need to grant to a user to let him to read a table in a linked server object?



Thanks

View Replies !   View Related
Grant Win Acct Permission
I'd like to grant a WIndows account permission to connect to a db andexec stored procedures. But am having trouble.I want this type of effect but can't get the syntax correct:USE MyDBGOCREATE USER 127.0.0.1ASPNET --ASPNET Account for current machineGOGRANT EXECUTE ON AllStoredPRocs TO 127.0.0.1ASPNETHow is this done in a t-sql script?Thanks for any help.

View Replies !   View Related
MSDE - Grant Permission?
Hi all,

If I would like to create a user with a db_owner permission & some permissions such as sp_addlogin, sp_adduser etc.

How can I do? Would you mind to give me some examples?

Many thanks.

View Replies !   View Related
How To Grant Permission To User?
Hi,
I newly created one database (using creat database testdb ). After that i created login name and password for that database ( using create login login1 with password = 'pass1'; use testdb; command) and i created user for that login name ( using create user user1 for login login1 command).
Then i connected testdb database using login1. But when i trying to create table in that database, it thrown error. Anyone please tell me that how to assign all privileges to the user user1?

Sathish kumar D

View Replies !   View Related
UDA Grant Permission Problem
When I try and grant execute permission to an assembly like this:
GRANT EXECUTE ON ASSEMBLY::[UDAs] TO [lgnMyLogin]

I get this error:
Incorrect syntax near 'EXECUTE...'.

Any ideas?

View Replies !   View Related
Grant Select Permission On All Tables
Hi Gurus, Can any one tell me how to grant select permisision all tables in a DB

like Grant all on [all tables] to myuser.


Thanks in advance.
Srinivas varanasi

View Replies !   View Related
Grant Drop Table Permission
I am getting the following error:

Server: Msg 165, Level 16, State 10, Line 1
Privilege DROP <object> may not be granted or revoked.

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TABLE'.


when I execute the following command:

GRANT DROP TABLE
TO [DU02Estimates]

View Replies !   View Related
How To Grant Permission To Create A New Object
I am new to sql server. right now i getting used to management studio.I am trying to creata a new object / a new database but i am getting an error which says permission not granted

can any help me to move ahead

thanks

View Replies !   View Related
Grant Execute Permission In 2000
does anyone know how to do this, its :

GRANT EXECUTE ...

for 2005 but for 2000?

View Replies !   View Related
Grant Permission On More Than One Table In A Single Command
Hi

Does anyone know how i can grant select permission on more than one table in the same database using a single grant commmand....its painful to use grant statement seperately on each table

thanks and regards,
reshma

View Replies !   View Related
How To Grant Sysadmin Permission To SQL Server User ?
Hi,

I'm trying to run the Bulk Insert statement but in order for me the run it, i need to have the sysadmin permission. Can someone show me how to grant sysadmin permission to my SQL Server user? This is really urgent. Thank you in advance.

View Replies !   View Related
How To Grant Permission To View Stored Procedures?
On our production SQL 2005 servers I want to give developers readonly access to each user database and also give them the ability to see stored procedures. Readonly is handled through db_datareader, but how do I give them the ability to see stored procedures without granting permission to execute them?

Thanks, Dave

View Replies !   View Related
How To Grant User Permission To Create Other Users?
There's something I can't quite figure out about user creating



The application that I'm currently working on is interacting with DB, therefore every time you use application you need to login as user which is fine. The problem is that certain users should be able to create new users and the new user mayeven have the same level of permissions as the one that's creating it ( like admin creating another admin acount or some like that).



Question is how can I allow users to create these user with giving them as few permissions as possible.



If there's is somewhere a code sample on the net I would appreciate the link.









View Replies !   View Related
How To Grant Permission To A Specific User To Run SQL Scheduled Jobs?
Hello Everyone,

I have an web application where the users has to run SQL scheduled jobs from the webpage. How to assign permission to a specific user to run specific jobs without making them a member of a Sysadmin role?

Any ideas you all smart people?
Thanks in advance!

Jannat.

View Replies !   View Related
How To Grant Create Procedure Permission To Database User?
Can somebody tell me without pointing to any other link how to grant Create Procedure permission to DB user.


View Replies !   View Related
What Permission I Need To Grant To A User If He Need To Read Or Write A Link Server Tables
hello,



What role or system privilege do I need to grant to a user if he need to read the data from a table which is in a link server object? where I can findthedocument about these commands.



Thanks

View Replies !   View Related
Grantor Question
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 Replies !   View Related
GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] Prevent Grant From Being Automaticly Add To Each Column


GRANT SELECT ON [dbo].[TblAreaCatmap] TO [admin] prevent grant from being automaticly add to each column?

Is there a way when you issue a grant select to a table or a view to not also grant select for each column.

The problem is when you use the grant command it automaticly adds the grant command to each column. I want to grant the permission at the table level so when the table is scripted it only has a single grant command instead of a grant for the table and a grant for each column which is not needed.

The sql managemnt studion interface will allow you to do this but onlt by using the interface. If you issue the above command from a query window it also creates A GRANT FOR EVERY COLUMN. How can I stop this behavior.

View Replies !   View Related
How To Grant Create View Access Without Grant Alter On Schema::
In SQL Server 2005 SP2 I want to grant the ability to create views to a user but in order to do this it requires that the users has the ability to grant alter on a schema.

Is there any way to grant this privilage without granting alter on schema also?



View Replies !   View Related
SQL Server - Permission Issues : Execute Permission Denied On Object 'SprocName'
I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I  could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
 

View Replies !   View Related
Insert Permission Denied After Granting Permission


SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?

Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D".No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again- straight SQL - as User "A"and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do aSQL.Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?




View Replies !   View Related
How To Use GRANT
I have a table where I have stored all the stored procedure names in a table (ProcList) and to which type of functionality it belongs.
I want to GRANT permissions on a group of sp's to a user. I have tried a statement like this:

GRANT execute on (select ProcName from ProcList where id = 1) to Username

This statement is not working, the (select...) part seems to be wrong.
Any ideas on how I can achieve what I want to do?

Thomas

View Replies !   View Related
GRANT Like My SQL?
Hi,

I was wondering, how do I make a user for my php app, like I do in MySQL?

View Replies !   View Related
Sql User Grant.
so here i go explaining my problem: I create an empty database. then I use the .net aspregsql tool to make the tables and the procs and everything, and it does. when i view my database it has the 11 empty tables the sprocs and the roles and everything. BUT when I open up the "asp website configuration" to add some users, it gives the following error:EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'masfeni_fakebetsdb', owner 'dbo'. 

View Replies !   View Related
Grant Access ...
I have created a table with ..
username, password, grant
username and password are nvarchar
grant is a bit
I want to check the availability of the username and password and then check if it is granted to access or not ..
so I made a selection query for getting the grant when username ==x and password = y
x=data come from another page
y=data come from another page
then put the selected grant or deny ( true or false) in a data set ..
and then check if it is grant ( true) to complete what I want >>>
else ( deny ....( false )) to return a reponse of deny username or password...
but everytime the dataset is empty ..
this is my code ... 
sqlConnection1.Open();
SqlDataAdapter da=new SqlDataAdapter("select grant_deny from users where username='"+Request.QueryString["username"]+"' and password='"+Request.QueryString["password"]+"'",sqlConnection1);
da.Fill(ds,"users");
sqlConnection1.Close()
if (ds.Tables[0].Rows[0]["grant_deny"].ToString()=="true")
{
.
.
.
.
}
else
{
Response.write("error");

what is wrong ..??
and if there is anyone has another solution for what I want .. I appriciate any sample code,...
thanks in advance..

View Replies !   View Related
WITH GRANT OPTION
I need to check if any user in the database is assigned any permissionWITH GRANT OPTION. Please let me know how do I check this. Also let meknow if assigning rights WITH GRANT OPTION is possible from enterprisemanager.Thanks in advanceKamal

View Replies !   View Related
Grant Permissions
Hi all,

Can I grant select only permission on all objects in the database? I have users that I need to give view access only on stored procedures, triggers, and functions. Thanks.

View Replies !   View Related
Grant Problem
Hi All,

I did SA commands in T-SQL queries (i.e: disk init, create database, dump,
load database)on a NT machine, that works fine.

But if I run the same queries on another machine that I don't know how
SQL/server was installed I 've got the following error:

Description - [[SQL Server]xpsql.c: Error 1314 from LogonUser on line 363

I've double checked the User privileges, the NT group without success.
Has anyone known that problem ? I haven't any clue.

Thanks
Herve
hmeftah@aol.com

View Replies !   View Related
Grant/Revoke
Can someone explain ..what is the basic difference between TSQL Stmts Grant and Revoke?
A reply will be highly appreciated
Thanks

View Replies !   View Related
SQL7 Grant All
Is anybody aware of how to "Grant All" to object permissions in SQL7. Has this functionality disappeared ?

Any help would be most appreciated.

View Replies !   View Related
Grant Permissons
Hello All,

I have 2 logins

1. Login1 ( has dbo permissons)
2. Login2 ( Data reader )

I have Created a table Tbl1 using Login1 ,

I have used grant statement to give select permissons to Login2

When I connect to the database using Login2 and use the T-Sql :- Select *
from Tbl1 , I get an error saying Invalid object name 'Tbl1'.

Thanks in Advance

View Replies !   View Related
Grant Permissions On SP's
I am trying to write a SQL script that grants execute permissions on all stored procedures for a single user (test_user).

I am running SQL server 2005

Does anyone have a script to do this.

Many thanks

View Replies !   View Related
GRANT EXECUTE ON [GRANT EXECUTE]
Hi,

I want one of my database users to be able to grant execute to procedures, but I don't want the user to have sys admin rights.

Is this possible. Kind of a statement like the following:

GRANT EXECUTE ON [GRANT EXECUTE] TO myuser

Thanks in advance

View Replies !   View Related
Grant Command
hi to all,

can anyone tell me what is differences between take ownership and control permission in sql server 2005?

thank you
honey sachdeva

View Replies !   View Related
Grant On All Tables
Hi,

is there a way to grants object privileges on
all tables of database to an user?

like this:

grant select, insert, update, delete on <all tables> to usernamedb
go

thanks!!!!

View Replies !   View Related
Unable To Grant For SqlQueryNotificationService
GRANT SEND ON SERVICE::SqlQueryNotificationService TO guestI need to run that T-SQL command to allow Query Notifications and I keep getting this error.Cannot find the service 'QueryNotificationService', because it does not exist or you do not have permission.I am logged in with my user account with Administrator rights along with just about every permission I can think of for the SQL Server account. I even logged in as SA and it also fails when trying to run this command. This is being done on SQL Express. So I also logged into my Windows 2003 Server with a fresh install of SQL Server 2005 Dev Edition and this also fails with the same error.Clearly I need some permission correction or something else is missing from both installations.Please help!  

View Replies !   View Related
Grant All Privileges To A User
Is it possible to grant all privilege for all tables of a specified database through script? Because i have to send the script to user side and i can't do it manually in Enterprise Manager.regards,

View Replies !   View Related
Can I Grant All Privilege To User?
it is possible to grant all privilege (CRUD) to specified table to user. But, now, i want to grant all privilege (CRUD) of all tables, views, sp, ... of database to the user. is it possible?regards,

View Replies !   View Related
Grant ASPNET All Access
hello all,

I would like to grant the MACHINENAMEASPNET user all acccess to my MSSQL database (i.e tables and stored procedures. I can do this through enterprise manager but id rather do it programatically so i can add it to my database creation script. What is the syntax for this?

I thought it would be along the lines of:

Grant all on databasename to localhostASPNET.

But obviously its not! Please help!

thanks

Tom

View Replies !   View Related
How To Grant Access To Sql Database
i am working on a project using asp.net and microsoft sql server, i am now working on my home pc. so now the problem is whenever i try to access the database through asp a error message such as :

[OleDbException (0x80040e4d): Login failed for user 'JYHENGASPNET'.]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
JYHeng.USRRegistration.Page_Load(Object sender, EventArgs e) in C:Documents and SettingsHeng Jang Yang.JYHENGFYPFYPCacheJYHENGJYHengUSRRegistra tion.aspx.vb:63
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
will appear.
my connectionstring used is :
objCn.ConnectionString = "Provider=SQLOLEDB; Data Source=(local);Initial Catalog=fyp;Integrated Security=SSPI;"

i am told that i must check if my aspnet user have been granted access to the database. however i am not sure on how to check the access, not to mention granting accsss. How am i supposed to grant my aspnet user access to my sql database?

Can someone please help me ? i am really lost. thank you

View Replies !   View Related
How To Grant Execute On Xp_cmdshell??
Can anyone help me please.
Healp please.
Does anybody know how to make xp cmdshell runnable for users other than Admin. It should be possible to grant execute to others, but i can't figure out how.

This is what i found:

Be aware that when you grant execute permission for xp_cmdshell to users, the users will be able to execute any operating-system command at the Windows NT command shell that the account running SQL Server (typically local system) has privilege to execute.

To restrict xp_cmdshell access to users who have administrator permission on the Windows NT-based computer where SQL Server is running, use SQL Setup or SQL Enterprise Manager to set the server options, selecting the "xp_cmdshell - Impersonates Client" option. With this option selected, only users who have connected to SQL Server via a trusted connection and are members of the local Administrators group on that computer are allowed to use xp_cmdshell. The commands run by xp_cmdshell continue to execute in the server's security context.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved