sql server 2000 grant select on table1 to @logname提示to @logn

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/21 09:36:10

sql server 2000 grant select on table1 to @logname提示to @logname语法错误
其中@logname为局部变量

如果是在存储过程中可以这样用,但是一个单独的SQL语句,不能这样使用
Create Procedure gr
@logname varchar(20)
as
grant select on table1 to @logname
执行时用：
Exec gr 'user1'
即把权限给了user1

sql server 2000 grant select on table1 to @logname提示to @logn grant select,insert,update,delete on bookmarks.* to bm_user@ grant select on table student to zmk(zmk是用户名) 2005编译不过说 to 附 GRANT SELECT ON Student,Course TO U2,U3; 消息 102,级别 15,状态 1,第 failed on connecting to server SQL 2000 中 grant 的用法英语翻译1、SQL Server is designed to allow thousands of users to mysql> grant all privileges on *.* to root @’%’ identified b grant all privileges on Students.Student,Student.Course to U 英语翻译Check if the access to SQL server is in Windows Authenti You don't have permission to access / on this server. Please remove scriptpack to play on this server