Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for


I'm trying to execute the following line:

EXEC sp_trace_setstatus @traceid = 1, @status = 0
but I get the following error:

You do not have permission to run 'SP_TRACE_SETSTATUS'.

I am running under an administrator account and the ALTER TRACE permission has been granted on this as well. I even tried the sa account but to no avail. Any help would be appreciated!

View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Sp_trace_setstatus 1,0 Shuts Down SQL Service
Has anyone ever not been able to stop a server side trace?

When I try, SQL Service shuts down. No errors are logged. I just get a general network error - connection broken.

sp_trace_setstatus 1,0

Thanks - Rick

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.

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 a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?

View Replies !   View Related
Don't Have Permission
I tru to add connection to my db in Visual Web Developer 2008 express.
Data source: - I use Microsoft SQL Server Database File (SqlClient).
Under Data File Name: I browse and choose the database and I get this error message
"ECommerceDbYou don't have permission to open this file. Contact the file owner or an administrator to obtain permission." WHat should I do? I already give full control to all users.
My environment is ms sql 2005 express and window vista business version. Thanks for any help.

View Replies !   View Related
every things at sql2005 have to permission
table , create , select , stored procedure
every things have to make permission to NT AUTHORITYSYSTEM
at last i do every thing without permission how can i make it without it

View Replies !   View Related
can someone please tell me whats the problem with this?
I actually gave that user permission and and still did not work, the DB is in the appdb folder and the network services user is granted full permisions on that folder!
Any ideas

View Replies !   View Related
Hello, Can anybody explain why a new loggin with Master Database as the Default Dafault Database without any clear permission to a particular database would allow me selection in a pubs or northwind database for an example. Thanks

View Replies !   View Related
DTS Permission
I created a DTS package to extract data to a text file.

I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .

Is that possible?

Thanks in advance


View Replies !   View Related
DTS Permission
I have created a DTS package that get a information form a text file and insert the data into a table and package is save as Structured Storage File. Now I am calling this DTS package thru VB application. The pacakge is save under folder that is shared to everyone.

When I run the VB application it runs fine using my login. but when I login as other user(webapp) it does not work. Webapp has DBO rights to the database that importing the data.

I am not sure if this is a permission issue or not.

Thank You,

View Replies !   View Related
Permission Using T-SQL
I have a database with over 100 tables. I need to add a user with deny permission on all tables except one. Is there a way of doing this without having to enter the names of all the tables and not using EM and ticking over 100 boxes? I tried to write the script using a select from sysobjects where xtype = 'U' but it didn't like it very much!!

Any help would be greatfully appreciated.

Many thanks

View Replies !   View Related
Hi, is there a smarter way to grant permissions on a lot of tables to a user rather than accessing the "Permissions" button on the Database User's Properties?

In SQL 6.5 there is "Object Permissions" that lets me "Grant All". Isn't there a similar way to do it in SQL 7?

View Replies !   View Related
DTS Permission

The user is trying to create DTS Packages from VB Application and he has data read and data write permission on all tables , views and store procedure on that database , but he gets Critical Error: -2147217911
Error source: Microsoft Data Transformation Services
Error Description: The parameter is incorrect

Any help is appreciated


View Replies !   View Related

I have a user that I need to grant access to a database, he should be able to ...

* create/edit/delete tables, views and stored procedures

So I created a user and then set his default database to the one he should access, then in user_mapping for that database I have checked.


But when this user try to access the tables with Sql server management studio he get this error "The select permission was denied on the object 'extended propoerties', database 'mssqlsystemresource', schema 'sys'. Microsoft SQL Server, Error: 229)"

What do I need to change in order to get this to work?

View Replies !   View Related
How can set select, add, delete & update permission for objects in a database for a particular  user/role in SQL 2005.
In SQL 2000 I could see all the tables listed under permission so that I could give a tik for permission

View Replies !   View Related
Permission For All
hi all,

we have so many logins in sql server 2005 .  i want to reduce the permissions of the users.
changing permissions to each and user is little bit difficulty .


database level : - db_writer and db_reader, and execute permissions .
i have to grant these permissions only .is there any chance to give for all users
can any one suggest the issue..

View Replies !   View Related
Sql Permission
What's Defference between  Control Server And SysAdmin Role

View Replies !   View Related
Permission Problem
In sql server 2005, what is minimum right a user need to view the content of stored-procedures? That is, in SSMS the user will be able to right click a stored-procedure and then select "Modify" to view the content, but the user has no permission to promote it? Thanks! 

View Replies !   View Related
Confused About Permission
I read a few articles on best SQL practices and they kept coming back to using a Least Privileged Account.  So I did so and gave that account read only permissions.  The articles also said to do updates use Stored Procedures - so I created stored procedures for updating/deleting data.So here's my problem - I connect to the database using the Least Privileged Account, I use the Stored Procedures, but .NET keeps saying I lack permissions.  If I GRANT the Least Privileged Account UPDATE/DELETE permission on the table, the Stored Procedures run perfectly.  But isn't that EXACTLY what I'm trying to avoid?My greatest concern is someone hacks my website and using the Least Privileged Account, they delete all my data using that account.  So I don't want to give the Least Privileged Account the Update/Delete privileges.Thanks a MILLION in advance! 

View Replies !   View Related
Permission Denied
iam working with http location and using sql server 2005 its getting an error as "INSERT permission denied on object CourseDetails, database 'mydb', schema 'dbo'." "CourseDetails" is my table name "mydb" is database name i worked same project with filesystem location ,there it is working

View Replies !   View Related
Permission Denied
iam working with http location and using sql server 2005
its getting an error as "SELECT permission denied on object UserDetails' database 'elearning', schema 'dbo'."
"UserDetails" is my table name
"elearning" is database name
i worked same project with filesystem location ,there it is working

View Replies !   View Related
Permission Error
i have my sql server database set up but when i try to run my app i get this error: help you be grateful :)

View Replies !   View Related
Permission Problem
Windows 2000 server, service pack 4, RAID 5 array, 2Gb RAM, SQL server 2000.

.Net framework 1.1 installed and runs happily UNTIL you try to access anything to do with data.

I've got a c# page, imported all relevent namespaces etc. This runs fine on other servers and my XP Pro machine. However, when put on this server, all I get is

Exception Details: System.UnauthorizedAccessException: Access is denied.

I've tried explictly setting permissions on the file, directory etc, but nothing I've found can get the file to work, yet other c# pages which don't use SQL connections work fine !

The offending line:

Line 31: SqlCommand sqlCmd = new SqlCommand(sql,sqlCon);
Line 32: sqlCon.Open();
Line 33: SqlDataReader datareader = sqlCmd.ExecuteReader();
Line 34: while (datareader.Read()

is line 32.


[UnauthorizedAccessException: Access is denied.]
System.EnterpriseServices.Platform.Initialize() +497
System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb) +11
System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl) +797
System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl) +170
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +356
System.Data.SqlClient.SqlConnection.Open() +384
ASP.test_aspx.Page_Load(Object sender, EventArgs e) in C:Inetpubwwwrootfishfood est.aspx:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

I've copied this directory and set up another application on another server and it works fine!

Anyone got any ideas?

View Replies !   View Related
SQL Permission Problem
I have downloaded and installed the forum on my website but I am having a problem with permsissions on one of the SQL tables. The default.aspx page comes up but when I try to view one of the forums I get the following error message.

SELECT permission denied on object forums_Threads database ower dbo

I have used enterprise manager and checked to make sure that the account I log in with listed in the Web.config file has the correct permissions to access this table and all fields within it. Everything looks ok but I still get the error.

Any help would be appreciated



View Replies !   View Related
Database Permission
Could someone please tell me how I can trap permission errors on a stored procedure:ie. Execute permission denied on object 'sel_mytable', database'mydatabase', owner 'dbo'I would like to print a message likeresponse.write("You don't have permission to select on this table") asopposed to the cryptic message I am receiving.Thanks in advanceJulie Barnet

View Replies !   View Related
Access Permission
it is proberly not right place to post here, but i found there are many experts here. I learn a lot from here. I would like to ask.
I have a new window 2000 server.
my supervisor let me set Domain Admins to both of us, how to set up?
The domain admins is full control, also we have admin for server, what is different? Is that Domain admin has been add in the server, and just let me add two users to be a domanin admins? how to do that? Thanks for your help.

View Replies !   View Related
Access Permission
Hello, I had database called test in sql server as backend. I create a user that can access this database (data entry, edit, etc). I want to have another user only can read this test database. How can i do this. In sql server, i create a new user, i try to give him permission, but i foud, he still can edit. How can i do this? Thanks.

View Replies !   View Related
User Permission

I grant read/update/insert permission on the speicific columns of the table on the users. I want to write the T-SQL to retrieve what permission/column permission does the user have.

View Replies !   View Related
Permission Problem
How to give user permission to be able to compile an SP?

View Replies !   View Related
Execute Permission
i have created a user in my databases and have given all the rights on all the objects in my database. i have a table in my database known as "employee" . I am developing a software which is using sql 6.5 server and vb 6.0. i have created users and given them permissions for the reason of security. i have given all the permissions to a user,
even after that whenever the software is run with his login and password , he is not able to access one table "employee" . the problem is that this is a master table , so it is vital to access this table . i am using a connection in VB to access sql server. the error messages it gives is as follows " runtime error , execute permissions denied on table , employee" . the user is able to login in sql server through the software but unable to access the table employee.
moreover i have read that execute permission is required for only stored procedures and not for tables . i have not give the alias of "sa" to that user but have tried even giving all access to all the objects of the database, but still the error continues.i am not using integrated security of NT server. please help

View Replies !   View Related
Permission On Sp_helplogins
We're runnning SP5A, and I logon to an a/c which map to the public group in the master db, if I execute sp_helpprotect on stored procedure sp_helplog and sp_helplogins, both of them indicates permissions to execute is granted to public.
Owner Object Grantee Grantor ProtectType Action Column
----- ------------- ------- ------- ----------- ------- ------
dbo sp_helplogins public dbo Grant Execute .

I have no problem in executing sp_helplog, however, when I tried to execute
sp_helplogin, I got
"Msg 15003, Level 16, State 1
You must be System Administrator (SA) to execute this stored procedure."

Anyone knows why ??? I thought the sysprotects system table is where to control permission to execute stored procedure, is this an exception...

View Replies !   View Related
Permission On Msdb
How would you set up a task run by user without sacrificing the alias permission on msdb (SQL 6.5)?

I have set up a task for runing replication by a user with the alias permission on msdb in order for the user to run the task. And I do not want to grant the alias permission to the user for the security reason. But if I set it up by granting only the sp_runtask permission to the user on msdb I always got the message like "You cannot perform this action on a task you do not own."

Please share your workaround. Thank you ahead of time

View Replies !   View Related
Permission Problem
We have a role in two databases , Both have the same permissions. One works fine thro' our application , The other doesn't.

We think this role is corrupted. And dropping and recreating will not fix this. We were told that this is a known bug. Has anyone experienced this problem and how did you fix this?


View Replies !   View Related
Database Permission
Hello Guys,

In SQL 7.0 when I give Permission to user to database, I've to do lengthy procedure. In Database user properties in SQL EM, I've to go and click each objects select Insert update delete Exec and DRI. Is there any other short way?

Thanks In Advance.

View Replies !   View Related
Permission Error
I have developer who is working With VB using COM objects for creating a webpage, and he is making a connection to SQL server using NT account. the NT account has datareader,datawriter and exec SP on the database that the COM objects is calling. But he get the following error 'Login failed for user 'NT AUTHORITYANONYMOUS LOGON''when click on the webpage that was creted using VB.

Does anyone know why would this happend.

Thank You,

View Replies !   View Related
Permission Denied....
Whne I try to create a procedure in a database , it throws an error saying

"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"

Though I am a part of db_owner and ddl_admin fixed database role.

What could be the reason behind it?

View Replies !   View Related
Permission Limit
hello everybody
I created user "MyUser " with rights
1. public for database "Orders"
2. select, update,delete, insert to table Orders.dbo.PersonalInfo

I have table Orders.dbo.PersonalInfoChangeLog
( it keeps information on any update on Orders.dbo.PersonalInfo including

So I don't want anybody to see even structure of this table(Orders.dbo.PersonalInfo ).

if person loged as "Myuser" he can use
1. sp_help PersonalInfoChangeLog
2.Enterpise Manager to see properties of the table

How can limit rights to see structure without generating Application role ?


View Replies !   View Related
Account Permission
You are a memeber of your company's SQL server 7.0 sysadmin fixed server role, and you are also a member of the windows NT Managers group. Both your individual windows NT user account and the Managers group account were previously granted the SELECT,INSERT,UPDATE and DELETE permissions for the DEPARTMENT table in the EXCUTIVE database. Joan, another memeber of the sysadmin role, revokes the SELECT and INSERT permissions from the managers group and denies your user account the UPDATE and DELETE permissions DEPARTMENT table in the EXECUTIVE database. What are your resulting permissions for DEOARTMENT table in the EXECUTIVE database when log in to SQL server using your individual wiindows NT user account ?
A. You can't select,insert,update or delete data in the DEOAARTMENT table.
B. You can select,insert,update or delete data in the DEOAARTMENT table.
C. You can only select and insert in the DEOAARTMENT table.
D. You can update and delete data in the DEOAARTMENT table.
Answer: B.
i think the answer should be C, because update and delete permissions are denied.
can anyone explain it for me? thanks.

View Replies !   View Related
Truncate Permission

Is there a way to give a user a Truncate permission on a table without being in sysadmin role or dbo.


View Replies !   View Related
Execute Permission
How do I grant execute permissions on system stored procedures or an extended stored procedure in the master database to a regular user in a different database? Do I need to create the user in the master db also for the permission to given.


View Replies !   View Related
MS SQL Permission Setting
Does anyone know if it is possible to set permissions on certain fields in a way that will restrict access for reading a field but will allow a user to do a select using that field? I am looking for a way to block read access to a sensitive field but I want to be able to query other fields using the value that is in the field.


View Replies !   View Related
Permission Issue With DTS And ASP
Please, help me. I am calling a DTS Package from an ASP page using stored procedure and xp_cmdshell.
DTS package transfers data from SQL tables to excel files to network shared directory. I am getting a access denied error when the DTS package fails. I used the UNC path for the Excel files within DTS package.
I can run the DTS Package from Enterprise Manager successfully, but cannot run it from the ASP page.

Thanks for any and all help.

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
Granting Permission

I need to grant SELECT permission for ALL TABLES for tables which are tag to role (eg. ABC).

How do i grant them "permanently"? as the tables o/p by role (ABC) will be dropped and recreated when another users rerun the tables?

Appreciate any help.

Thanks very much!!

View Replies !   View Related
Update Permission
I only give a user permission to update and connect to the database and I get an error that I need select permission as well when I run an update. Is this normal? I also have the same issue with delete permission and needing select permission. Thanks for any help you provide.

View Replies !   View Related
Permission Error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]You do not have permission to use the bulk load statement.

I am getting this error when running from an asp script and trying to execute my stored procedure that reads an xml file.

Please advise?

View Replies !   View Related
SHOWPLAN Permission

How can I provide SHOWPLAN permission.


View Replies !   View Related
Permission Issue !!

We have a problem here where there is a request to grant dbo access to tempdb as the application developers are trying to create a global temporary table inside tempdb database. The SQL login does a bulk insert to the temporary table in tempdb ans then loads it in a permanent table inside one user database. Howeever the job is failing with message as :

" The current user is not the database or object owner of table '<table_name>'. Cannot perform SET operation. "

I checked the MS article and it says that DBO permissions needs to be granted for tempdb database. We want to avoid that and would like to know is there is any alternative way where the SQL id could be granted privileges to create , alter , delete and insert tables straight inside the user db ( not tempdb ) without DBO access. The program will run as and when required and everytime it will creat a new table.

Any ways to address this alternatively would be of great help.

Thank you.

View Replies !   View Related
Permission Window
Running sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it should be.
In this window I do not see System Administrator and System User column. I see a different window i.e. permission, Grantor, Grant, WithGrant, Deny columns.
Any thoughts please?

View Replies !   View Related

Copyright © 2005-08, All rights reserved