sql 7 数据库,每个客户端应用程序用户只拥有Public角色的权限,在数据库中已设置Public角色不具备对数据库内任何Object的操作权限.客户端应用程序启动后激活一个应用程序角色 APP_ROLE,此角色定义的所有的操作权限.
问题:
Private Sub cboContractNo_Click()
Dim adcmd1 As New ADODB.Command
Dim adpara1 As New ADODB.Parameter
Dim adrs1 As New ADODB.Recordset
Dim adcmd2 As New ADODB.Command
Dim adpara2 As New ADODB.Parameter
Dim adrs2 As New ADODB.Recordset Set adcmd.ActiveConnection = padcnnCCS
adcmd.CommandText = "SP_1"
adcmd.CommandType = adCmdStoredProc
Set adpara1 = adcmdTmp.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)
adcmdTmp.Parameters.Append adparaTmp
set adrs1 = adcmdTmp.Execute
...
Set adcmd2.ActiveConnection = padcnnCCS
adcmd2.CommandText = "SP_2"
adcmd2.CommandType = adCmdStoredProc
Set adpara2 = adcmdTmp.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)
adcmd2.Parameters.Append adparaTmp
set adrs2 = adcmdTmp.Execute
...
End Sub
当程序运行 set adrs2 = adcmdTmp.Execute 发生错误!说没有权限运行 sp_2! 实际上应用程序角色 APP_ROLE是具备运行sp_1和sp_2的权限的,在代码中随便注释任何一段EXECUTE代码都能正常运行,可两个EXECUTE命令一起运行时就说无权限运行!为什么呢?
请高手指教.
问题:
Private Sub cboContractNo_Click()
Dim adcmd1 As New ADODB.Command
Dim adpara1 As New ADODB.Parameter
Dim adrs1 As New ADODB.Recordset
Dim adcmd2 As New ADODB.Command
Dim adpara2 As New ADODB.Parameter
Dim adrs2 As New ADODB.Recordset Set adcmd.ActiveConnection = padcnnCCS
adcmd.CommandText = "SP_1"
adcmd.CommandType = adCmdStoredProc
Set adpara1 = adcmdTmp.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)
adcmdTmp.Parameters.Append adparaTmp
set adrs1 = adcmdTmp.Execute
...
Set adcmd2.ActiveConnection = padcnnCCS
adcmd2.CommandText = "SP_2"
adcmd2.CommandType = adCmdStoredProc
Set adpara2 = adcmdTmp.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)
adcmd2.Parameters.Append adparaTmp
set adrs2 = adcmdTmp.Execute
...
End Sub
当程序运行 set adrs2 = adcmdTmp.Execute 发生错误!说没有权限运行 sp_2! 实际上应用程序角色 APP_ROLE是具备运行sp_1和sp_2的权限的,在代码中随便注释任何一段EXECUTE代码都能正常运行,可两个EXECUTE命令一起运行时就说无权限运行!为什么呢?
请高手指教.
解决方案 »
- 请教关于VB回调函数的问题
- 求助:文本框输入2个数字后,光标自动跳到下个文本框
- 请问各位前辈:如何判断存储过程何时结束?
- 谁知道NNOTES.DLL结构?
- 急啊,大家帮忙,在ACTIVEREPORT 2。0中如何在打印该组头之前划一条细线,在打印该组的组尾之前划一条细线!大虾都到哪里去了?
- 高分:100分!
- 在richtextbox中如何插入ActiveX控件啊?
- 关于VB调用VC的DLL的问题!
- 用VB对Excel做报表的问题
- 1000大洋,求购制衣行业的打飞系统
- 技术探讨:QQ尾巴是如何实现的?来者有分,送完为止。
- 在程序中添加了Data Environment,运行调用出现:713“错误!怎么解决!
Set adcmd.ActiveConnection = padcnnCCS
adcmd.CommandText = "SP_1"
adcmd.CommandType = adCmdStoredProc
Set adpara1 = adcmd.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)'这里
adcmdTmp.Parameters.Append adpara1 '这里
set adrs1 = adcmd.Execute '这里
...
Set adcmd2.ActiveConnection = padcnnCCS
adcmd2.CommandText = "SP_2"
adcmd2.CommandType = adCmdStoredProc
Set adpara2 = adcmd2.CreateParameter("contract_uid", adInteger, adParamInput, , cboContractNo.Columns("contract_uid").Value)'这里
adcmd2.Parameters.Append adpara2 '这里
set adrs2 = adcmd2.Execute '这里