資料庫名:SleDa,資料表名:SleCuTb1
大意是取得SleCuTb1的使用者權限,可否詳細解釋此敘述的意思呢
strEnvUserName=Environ("USERNAME")
strSqlStmt$="select o.name,p.action" & _
"from SleDa.dbo.sysprotects p," & _
"SleDa.dbo.sysobjects o" & _
"where o.name='SleCuTb1'" & _
"and p.id=o.id" & _
"and p.uid=" & _
"(select u.uid" & _
"from SleDa.dbo.sysusers u," & _
"master.dbo.syslogins 1" & _
"where u.suid=1.suid" & _
"and 1.dbname='SleDa'" & _
"and 1.name='" & strEnvUserName & "')"