SHOWPLAN Permission
May 5, 2008Hi
How can I provide SHOWPLAN permission.
Regards,
Reddy
ADVERTISEMENT
Showplan Difference
Mar 9, 2001Hi,
I have a view in a database called PS_EMPLMT_SRCH_US and it joins around five tables. I have two databases which are identical structures including data. But when run one query
ie "SELECT * FROM PS_EMPLMT_SRCH_US where EMPLID like '00918%' and OPRCLASS like 'ALLPANLS' ",
response time is totally different even though both databases have same data and same indexes. When I looked at showplan and stats time, both are totally different and order of table fetch is totally different. Is there any idea why this difference? Any help would be appreciated.
Here is the show plan info:
-------------------------------------------------------------------
GOOD Performance Query and plan
-------------------------------------------------------------------
SELECT * FROM PS_EMPLMT_SRCH_US where EMPLID like '00918%' and OPRCLASS like 'ALLPANLS'
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 156 ms, elapsed time = 156 ms.
Table 'PS_SCRTY_TBL_DEPT'. Scan count 2, logical reads 4, physical reads 0, read-ahead reads 0.
Table 'PSTREENODE'. Scan count 13, logical reads 26, physical reads 0, read-ahead reads 0.
Table 'PS_JOB'. Scan count 29, logical reads 87, physical reads 0, read-ahead reads 0.
Table 'PS_NID_TYPE_TBL'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0.
Table 'PS_PERS_NID'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0.
Table 'PS_PERSONAL_DATA'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 5 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
PLAN:
|--Nested Loops(Left Semi Join)
|--Nested Loops(Inner Join)
| |--Nested Loops(Inner Join)
| | |--Nested Loops(Inner Join)
| | | |--Filter(WHERE:([PS_JOB].[EFFSEQ]=[Expr1016]))
| | | | |--Nested Loops(Inner Join)
| | | | |--Filter(WHERE:([PS_JOB].[EFFDT]=[Expr1012]))
| | | | | |--Nested Loops(Inner Join)
| | | | | |--Nested Loops(Inner Join)
| | | | | | |--Index Seek(OBJECT:([HRNEW].[dbo].[PS_PERSONAL_DATA].[PS#PERSONAL_DATA]), SEEK:([PS_PERSONAL_DATA].[EMPLID] >= '00918' AND [PS_PERSONAL_DATA].[EMPLID] < '00919') ORDERED)
| | | | | | |--Index Seek(OBJECT:([HRNEW].[dbo].[PS_JOB].[PS#JOB]), SEEK:([PS_JOB].[EMPLID]=[PS_PERSONAL_DATA].[EMPLID]) ORDERED)
| | | | | |--Table Spool
| | | | | |--Stream Aggregate(DEFINE:([Expr1012]=MAX([PS_JOB].[EFFDT])))
| | | | | |--Top(1)
| | | | | |--Index Seek(OBJECT:([HRNEW].[dbo].[PS_JOB].[PSAJOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID] AND [PS_JOB].[EMPL_RCD#]=[PS_JOB].[EMPL_RCD#] AND [PS_JOB].[EFFDT] <= Convert(Convert(getdate()))) OR
| | | | |--Table Spool
| | | | |--Stream Aggregate(DEFINE:([Expr1016]=MAX([PS_JOB].[EFFSEQ])))
| | | | |--Index Seek(OBJECT:([HRNEW].[dbo].[PS_JOB].[PSAJOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID] AND [PS_JOB].[EMPL_RCD#]=[PS_JOB].[EMPL_RCD#] AND [PS_JOB].[EFFDT]=[PS_JOB].[EFFDT]) ORDERED)
| | | |--Clustered Index Seek(OBJECT:([HRNEW].[dbo].[PS_PERS_NID].[PS_PERS_NID]), SEEK:([PS_PERS_NID].[EMPLID]=[PS_JOB].[EMPLID]) ORDERED)
| | |--Clustered Index Seek(OBJECT:([HRNEW].[dbo].[PS_NID_TYPE_TBL].[PS_NID_TYPE_TBL]), SEEK:([PS_NID_TYPE_TBL].[COUNTRY]=[PS_PERS_NID].[COUNTRY] AND [PS_NID_TYPE_TBL].[NATIONAL_ID_TYPE]=[PS_PERS_NID].[NATIONAL_ID_TYPE]) ORDERED)
| |--Filter(WHERE:(like([PS_SCRTY_TBL_DEPT].[OPRID], 'ALLPANLS')))
| |--Clustered Index Seek(OBJECT:([HRNEW].[dbo].[PS_SCRTY_TBL_DEPT].[PS_SCRTY_TBL_DEPT]), SEEK:([PS_SCRTY_TBL_DEPT].[OPRID] BETWEEN 'ALLPANLS' AND 'ALLPANLS') ORDERED)
|--Row Count Spool
|--Filter(WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate())) OR (([PS_SCRTY_TBL_DEPT].[ACCESS_CD]='Y' AND [PS_JOB].[EFFDT]=[Expr1022]) AND [Expr1031])))
|--Nested Loops(Left Semi Join, WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate()))))
|--Nested Loops(Inner Join, WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate()))))
| |--Clustered Index Seek(OBJECT:([HRNEW].[dbo].[PS_JOB].[PS_JOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID]) ORDERED)
| |--Table Spool
| |--Stream Aggregate(DEFINE:([Expr1022]=MAX([PS_JOB].[EFFDT])))
| |--Index Seek(OBJECT:([HRNEW].[dbo].[PS_JOB].[PSAJOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID] AND [PS_JOB].[EMPL_RCD#]=[PS_JOB].[EMPL_RCD#] AND [PS_JOB].[EFFDT] <= Convert(Convert(getdate()))) ORDERED)
|--Row Count Spool
|--Nested Loops(Left Anti Semi Join, WHERE:([PSTREENODE].[TREE_NODE_NUM]>=[PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM] AND [PSTREENODE].[TREE_NODE_NUM]<=[PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM_END]))
|--Index Seek(OBJECT:([HRNEW].[dbo].[PSTREENODE].[PSCPSTREENODE]), SEEK:([PSTREENODE].[TREE_NODE]=[PS_JOB].[DEPTID] AND [PSTREENODE].[SETID]=[PS_SCRTY_TBL_DEPT].[SETID] AND [PSTREENODE].[TREE_NAME]='DEPT_SECURITY' AND [PSTRE
|--Filter(WHERE:([PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM]<[PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM] OR [PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM]>[PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM]))
|--Index Seek(OBJECT:([HRNEW].[dbo].[PS_SCRTY_TBL_DEPT].[PSASCRTY_TBL_DEPT]), SEEK:([PS_SCRTY_TBL_DEPT].[OPRID]=[PS_SCRTY_TBL_DEPT].[OPRID] AND [PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM] BETWEEN [PS_SCRTY_TBL_DEPT].[TREE_NODE_
-----------------------------------------------------------------------------
BAD Performance Query and plan
-------------------------------------------------------------------------
SELECT * FROM PS_EMPLMT_SRCH_US where EMPLID like '00918%' and OPRCLASS like 'ALLPANLS'
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
Table 'PS_JOB'. Scan count 168595, logical reads 515067, physical reads 0, read-ahead reads 0.
Table 'PS_PERSONAL_DATA'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0.
Table 'PS_PERS_NID'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0.
Table 'PS_NID_TYPE_TBL'. Scan count 1, logical reads 3, physical reads 0, read-ahead reads 0.
Table 'PS_SCRTY_TBL_DEPT'. Scan count 2, logical reads 4, physical reads 0, read-ahead reads 0.
Table 'PSTREENODE'. Scan count 1, logical reads 2, physical reads 0, read-ahead reads 0.
SQL Server Execution Times:
CPU time = 15797 ms, elapsed time = 4500 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
|--Nested Loops(Left Semi Join)
|--Nested Loops(Inner Join, WHERE:([PS_JOB].[SETID_DEPT]=[PS_SCRTY_TBL_DEPT].[SETID]))
| |--Parallelism(Gather Streams)
| | |--Hash Match(Inner Join, HASH:([PS_PERS_NID].[EMPLID])=([PS_JOB].[EMPLID]), RESIDUAL:([PS_JOB].[EMPLID]=[PS_PERS_NID].[EMPLID]))
| | |--Parallelism(Distribute Streams, PARTITION COLUMNS:([PS_PERSONAL_DATA].[EMPLID]))
| | | |--Nested Loops(Inner Join)
| | | |--Nested Loops(Inner Join)
| | | | |--Index Seek(OBJECT:([HRTEST].[dbo].[PS_PERSONAL_DATA].[PS#PERSONAL_DATA]), SEEK:([PS_PERSONAL_DATA].[EMPLID] >= '00918' AND [PS_PERSONAL_DATA].[EMPLID] < '00919') ORDERED)
| | | | |--Clustered Index Seek(OBJECT:([HRTEST].[dbo].[PS_PERS_NID].[PS_PERS_NID]), SEEK:([PS_PERS_NID].[EMPLID]=[PS_PERSONAL_DATA].[EMPLID]) ORDERED)
| | | |--Clustered Index Seek(OBJECT:([HRTEST].[dbo].[PS_NID_TYPE_TBL].[PS_NID_TYPE_TBL]), SEEK:([PS_NID_TYPE_TBL].[COUNTRY]=[PS_PERS_NID].[COUNTRY] AND [PS_NID_TYPE_TBL].[NATIONAL_ID_TYPE]=[PS_PERS_NID].[NATIONAL_ID_TYPE]) ORDERE
| | |--Filter(WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate())) OR ([PS_JOB].[EFFDT]=[Expr1018] AND [PS_JOB].[EFFSEQ]=[Expr1022])))
| | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([PS_JOB].[EMPLID]))
| | |--Nested Loops(Inner Join, WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate()))))
| | |--Parallelism(Repartition Streams, PARTITION COLUMNS:([PS_JOB].[EMPLID], [PS_JOB].[EFFDT], [PS_JOB].[EMPL_RCD#]), ORDER BY:([PS_JOB].[EFFDT] ASC, [PS_JOB].[EMPL_RCD#] ASC, [PS_JOB].[EMPLID] ASC))
| | | |--Nested Loops(Inner Join, WHERE:([PS_JOB].[EFFDT]>=Convert(Convert(getdate()))))
| | | |--Sort(ORDER BY:([PS_JOB].[EFFDT] ASC, [PS_JOB].[EMPL_RCD#] ASC, [PS_JOB].[EMPLID] ASC))
| | | | |--Clustered Index Scan(OBJECT:([HRTEST].[dbo].[PS_JOB].[PS_JOB]))
| | | |--Table Spool
| | | |--Stream Aggregate(DEFINE:([Expr1018]=MAX([PS_JOB].[EFFDT])))
| | | |--Index Seek(OBJECT:([HRTEST].[dbo].[PS_JOB].[PSAJOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID] AND [PS_JOB].[EMPL_RCD#]=[PS_JOB].[EMPL_RCD#] AND [PS_JOB].[EFFDT] <= Convert(Convert(getdate()))) O
| | |--Table Spool
| | |--Stream Aggregate(DEFINE:([Expr1022]=MAX([PS_JOB].[EFFSEQ])))
| | |--Index Seek(OBJECT:([HRTEST].[dbo].[PS_JOB].[PSAJOB]), SEEK:([PS_JOB].[EMPLID]=[PS_JOB].[EMPLID] AND [PS_JOB].[EMPL_RCD#]=[PS_JOB].[EMPL_RCD#] AND [PS_JOB].[EFFDT]=[PS_JOB].[EFFDT]) ORDERED)
| |--Filter(WHERE:(like([PS_SCRTY_TBL_DEPT].[OPRID], 'ALLPANLS')))
| |--Index Seek(OBJECT:([HRTEST].[dbo].[PS_SCRTY_TBL_DEPT].[PSBSCRTY_TBL_DEPT]), SEEK:([PS_SCRTY_TBL_DEPT].[ACCESS_CD]='Y' AND [PS_SCRTY_TBL_DEPT].[OPRID] BETWEEN 'ALLPANLS' AND 'ALLPANLS') ORDERED)
|--Row Count Spool
|--Nested Loops(Left Anti Semi Join)
|--Index Seek(OBJECT:([HRTEST].[dbo].[PSTREENODE].[PSCPSTREENODE]), SEEK:([PSTREENODE].[TREE_NODE]=[PS_JOB].[DEPTID] AND [PSTREENODE].[SETID]=[PS_SCRTY_TBL_DEPT].[SETID] AND [PSTREENODE].[TREE_NAME]='DEPT_SECURITY' AND [PSTREENODE].[EFFDT]
|--Filter(WHERE:([PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM]<>[PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM]))
|--Index Seek(OBJECT:([HRTEST].[dbo].[PS_SCRTY_TBL_DEPT].[PSASCRTY_TBL_DEPT]), SEEK:([PS_SCRTY_TBL_DEPT].[OPRID]=[PS_SCRTY_TBL_DEPT].[OPRID] AND ([PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM], [PS_SCRTY_TBL_DEPT].[TREE_NODE_NUM_END], [PS_SCRTY_
SHOWPLAN Through ODBC
Feb 29, 2008I´m wriing a small perl script that connects to SQL Server through ODBC, using DBI and DBD-ODBC modules.
I can get data from a query, but I cannot get the execution plan for it... instead, I got "[Microsoft][ODBC Driver Manager] Function sequence error".
Using Profiler, I can see both "set showplan_xml on" and my query as "SQL BatchCompleted" events on target database. The same happens when I use "set showplan_text on".
Is it possible to get an execution plan through ODBC?
Thanks!!!
++Vitoco
SHOWPLAN Through ODBC
Feb 29, 2008I´m writing a small perl script that connects to SQL Server through ODBC, using DBI and DBD-ODBC modules.
I can get data from a query, but I cannot get the execution plan for it... instead, I got "[Microsoft][ODBC Driver Manager] Function sequence error".
Using Profiler, I can see both "set showplan_xml on" and my query as "SQL BatchCompleted" events on target database. The same happens when I use "set showplan_text on".
Is it possible to get an execution plan through ODBC?
Thanks!!!
++Vitoco
Grant Showplan To &&<user&&>
May 22, 2006
I was trying to review some query statistics and received the following message:
SHOWPLAN permission denied in database Test
I gave the user permission by the following command:
Grant showplan to user.
I am curious as to how much perfomance does this effect? Is there an alternative?
regards
SQL 2012 :: Powershell Script To Verify Showplan Enabled For User?
May 18, 2015I am looking for a sample PowerShell script that allows me to verify that showplan is enabled for a user on a SQL Server 2012 instance. Haven't figured out how to code it.
View 2 Replies View RelatedSQL Server - Permission Issues : Execute Permission Denied On Object 'SprocName'
Dec 13, 2005I 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,
Insert Permission Denied After Granting Permission
Sep 19, 2007
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?
Permission-1
Sep 13, 2007http://www.abvalve.com/careers/form/
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
Permission
Jan 18, 2008every 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
Don't Have Permission
Jan 27, 2008I 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.
DTS Permission
Mar 8, 2001I 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,
john
Permission
Aug 20, 1999Hi, 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?
Permission Using T-SQL
Nov 12, 2004I 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
Permission
Jan 15, 2008Hello, 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 5 Replies View RelatedDTS Permission
Mar 4, 2004I 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
Giorgio
Permission
May 12, 2008Hi
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.
db_Datareader
db_datawriter
db_ddladmin
db_denydatareader
db_securityadmin
public
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?
Sql Permission
Jan 28, 2007What's Defference between Control Server And SysAdmin Role
View 6 Replies View RelatedPermission For All
Feb 5, 2008hi 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..
thanks
manoj
Permission
Feb 20, 2008Hi,
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
regards
priw
Permission Error
Aug 7, 2006i have my sql server database set up but when i try to run my app i get this error:http://img308.imageshack.us/img308/2862/untitledep4.pngany help you be grateful :)
View 4 Replies View RelatedPermission Problem
Dec 16, 2006In 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 4 Replies View RelatedPermission Denied
Apr 10, 2007iam 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
Permission Denied
Apr 26, 2007iam 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 1 Replies View RelatedConfused About Permission
Aug 29, 2007I 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 3 Replies View RelatedPermission Problem
Jan 28, 2004Windows 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.
STACK TRACE:
[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?
SQL Permission Problem
Mar 19, 2005I 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
Thanks,
Glenn
Permission Error
Mar 27, 2001I 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,
john
Permission Denied....
May 18, 2001Whne 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?
Permission Limit
Jul 13, 2001hello 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
HOST_NAME())
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 ?
Thanks
Truncate Permission
Sep 6, 2001Hi
Is there a way to give a user a Truncate permission on a table without being in sysadmin role or dbo.
Thanks
Execute Permission
Oct 25, 2001How 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.
thanks
Permission On Msdb
Feb 8, 2001How would you set up a task run by user without sacrificing the alias permission on msdb (SQL 6.5)?
Situation:
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