Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server

Lars-Erik wrote:
Hi guys!

I have to eat all my statements including my hat.
Our customer actually figured it out this morning by changing to the
sa user instead of a limited one. Some of the procedures didn't grant
execute permission to public.
Since I do all the parameter stuff before execute, a security
exception is never thrown.
I might argue that .Refresh should've thrown an exception, but I'm
just gonna shut up and be happy it finally works. :)

From Erland Sommerkog, in the SQL Server MVP group in which I posted this
question:

And the reason that this is different in SQL 2005 is that in SQL 2000
metadata was visible to public by default. Not so in SQL 2005.

Rather than switching to sa, he should probably do

GRANT VIEW DEFINITION ON SCHEMA::dbo TO someuser



--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: ORA-01555 on source database for materialized view refresh across link
    ... Oh yeah, O9 puts the ORA-1555 SQL in the alert log, although it ... thrown by that SQL, the cause is usually something else (with the ...
    (comp.databases.oracle.server)
  • Re: Problem w/ VBScript running against SQL Server 2000
    ... but bayID is always assigned the value of bay_id. ... account for sql injection anyway. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... You will have to undo the manual allowed nodes settings and then follow the instructions in "maintaining a failover cluster" for recovery from failure scenario 1. ... SQL 2000 on Windows Server 2003 allows up to four nodes in a cluster so you should be good to go. ... > Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Breaking a Sql Cluster
    ... If you are not going to have any extra SAN space, ... then remove the old instance and install a *clustered* SQL ... 2005 instance on that same cluster. ... SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error -2147217900: failed to create SQL database
    ... We ran profiler to see what commands is the MSI passing to create the DB. ... SQL Server MVP ... database: ApplicationDb, ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)