grant update table to zhangsan;//修改表的权限 grant create session to zhangsan;//授予zhangsan用户创建session的权限,即登陆权限 ..
基于306个网页-相关网页
授予修改表的权限 grant update on tablename to zhangsan ; grant t update on tablename to zhangsan
修改任意表的权限 alter any table ; alter r any table
修改表空间的权限 alter r tablespace
修改任意表中行的权限 update e any table
修改拥有的表权限 alter r table
在这个例子中,pttuser用户具有数据库的读写权限(只限于来自Web服务器主机名),因此能够访问和修改它的每一个表。
In the example, the pttuser user has read and write access to the database (only from the hostname of the web server) and therefore can access and modify each table in it.
通过将注册表变量的路径集添加到当前权限对象的状态中,使用此方法修改对注册表变量的访问权限。
Use this method to modify access to registry variables by adding the set of their paths to the state of the current permission object.
对于适用的情况,更改脚本还将包括在正被修改的表上设置的权限。
For applicable scenarios, the change scripts may also include the permissions sets on the tables that are being modified.
应用推荐