被授予这个权限的用户可以创建私有视图和文件夹,并将它们存储在数据库所在的服务器上。
Users who are granted this privilege can create private views and folders and store them on the server that hosts the database.
当一个经过授权的用户创建一个SQL对象(比如视图)时,该用户的权限ID就被标记为对象的定义者。
When an authorized user creates an SQL object, such as a view, the authorization ID of the user is marked as the definer of the object.
在创建一个数据库时,系统编目视图上的SELECT权限便被授给PUBLIC(图6)。
When a database is created, SELECT privilege on the system catalog views is granted to PUBLIC (Figure 6).
一种解决方案是使用Showsinglecategory选项(参见图6)来创建嵌入视图,并且让用户从其拥有访问权限的类别列表中选择要显示的类别。
One solution is to create an embedded view using the Show single category option (see figure 6) and to have the user choose a category to display from a list of categories to which he has access.
查询和视图设计器不检查该名称是否已被使用,也不检查您是否有创建表的权限。
The Query and View Designer does not check whether the name is already in use or whether you have permission to create the table.
查询和视图设计器不检查该名称是否已被使用,也不检查您是否有创建表的权限。
The Query and View Designer does not check whether the name is already in use or whether you have permission to create the table.
应用推荐