阅读背景:

SQL Sever TSQL脚本如何告诉它具有哪些安全权限?

来源:互联网 

I have a TSQL script that is used to set up a database as part of my product's installation. It takes a number of steps which all together take five minutes or so. Sometimes this script fails on the last step because the user running the script does not have sufficient rights to the database. In this case I would like the script to fail strait away. To do this I want the script to test what rights it has up front. Can anyone point me at a general purpose way of testing if the script is running with a particular security permission?I have a TSQL script that is used to set up a d




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: