View Complete Post
I'm trying to determine the minimal amount of access I can give my developers to be able to run create stored procedure scripts with an inclusion of the grant execute to the application user group.
We have been developing some interesting work arounds, but I think there must be an easier way to grant the access.
Grant Create Stored Procedure to user1 on a specific database
Grant Permission to Grant Execute permission for Stored Procedures on a specific Database to user1 for any user.
Please comment the pros and cons of both methods.
Thanks in advance.
[UserID] = @UserID
I am getting an error while executing a SSIS Package from SQL Server Stored Procedure. But when I run it in BIDS, it executes successfully. Any help on this ???
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occured. Error Code: 0x80040ED. An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hresult 0x80040eD Description: "ORA-01017: invalid username/password; logon denied"
I have a parent window parent.aspx and a popup window popup.aspx. parent.aspx has a confirm button which on click open popup.aspx. This popup.aspx holds a filled application form like leave application form of employees and a email sending button. That button on click send emails to the specified email addresses with attachment. The how to create stored procedure in sql server ??? here i have 3 attributes i want to write a sp it should take 1input value by tht i get remaining 2out put values table name: Employeeattributes: id,name,sal;help me in this....if this exected i should get succecss msg also and boolen is true...elseflase and not exectuted msg... also
here i have 3 attributes i want to write a sp it should take 1input value by tht i get remaining 2out put values
table name: Employee
help me in this....
if this exected i should get succecss msg also and boolen is true...
flase and not exectuted msg...
I have upto 16 calculators(I mean 16 stored procedures) in one database.How do I log all inputs for each calculater(each stored proc)?.Most of the variables are not populated in the output table so it became hard to reproduce.The variables are not consistant across all the 16 procs . Do I need to set up new table for these inputs?
your help would be appreciated ..pls help how do I create a table or write a common proc ? Your help with the idea and code will be greatly appreciated!