I have three stored procedures: one inserts a record into TableX, one
deletes a record from TableX, and one selects a record from TableX. I have
granted EXECUTE permissions on all three stored procedures to UserX. UserX
can execute the insert and the delete stored procedures just fine, but when
UserX tries to run execute select stored procedure, the following error
message occurs:
The SELECT permission was denied on the object 'TableX', database
'DatabaseX', schema 'dbo'.
There must be something painfully obvious I am missing here, but I just
don't see it--thanks in advance for any help!
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.sqlserver.server)
Sybase, JDBC, AutoCommit, DDL IN TRAN ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC... I need to be able to set AutoCommit to false and execute multiple... (comp.lang.java.databases)
Re: Sybase, JDBC, AutoCommit, DDL IN TRAN ... > having executing Sysbase stored procedures via JDBC. ... > stored procedure which contains DDL and with AutoCommit set to false I ... > The explanation for this behaviour I have found is that the JDBC... > I need to be able to set AutoCommit to false and execute multiple... (comp.lang.java.databases)
Re: Records lost in an ADOStoredProc ... Use a thread to fire off the stored procedures so that your application ... Let's suppose it updates... > the CacheSize is set to 1; it is worse when I increase the CacheSize. ... > I don't need to show records, only to execute the store procedure. ... (borland.public.delphi.database.ado)
Re: call Stored procedure with no params ... All stored procedures are exposed as methods of the Connection ... This means you can execute a procedure "Fred" like this: ... so you have parameters (most SPs do). ... Where 5522.22 is a non-string parameter value. ... (microsoft.public.data.ado)
