主页 / dba / 问题 / 101543
Accepted
Mateus Viccari
Asked: 2015-05-15 10:13:59 +0800 CST

如何在 Firebird 1.5 上授予/撤销用户权限？

  • 772

我需要在 firebird 1.5 中创建一个用户并授予他访问某些特定表的权限。我设法创建了用户，但显然 GRANT/REVOKE 操作仅适用于 2.1 或更高版本。那么，该怎么做呢？

更新
实际上我弄错了，GRANT 和 REVOKE 在 1.5 版中都可以正常工作。

security firebird

1 个回答

  1. Best Answer

    Firebird 已经拥有GRANT并且REVOKE从其初始版本开始。请参阅http://www.firebirdsql.org/en/reference-manuals/上的 Interbase 6.0 语言参考（接近页面末尾）。

    例如GRANT：

    GRANT <privileges> ON [TABLE] {tablename | viewname}
      TO {<object> | <userlist> | GROUP UNIX_group}
  | EXECUTE ON PROCEDURE procname TO {<object> | <userlist>}
  | <role_granted> TO {PUBLIC | <role_grantee_list>};
<privileges> = {ALL [PRIVILEGES] | <privilege_list>}
<privilege_list> = SELECT
  | DELETE
  | INSERT
  | UPDATE [(col [, col ...])]
  | REFERENCES [(col [, col ...])] [, <privilege_list> ...]
<object> = PROCEDURE procname
  | TRIGGER trigname
  | VIEW viewname
  | PUBLIC
  [, <object> ...]
<userlist> = [USER] username
  | rolename
  | Unix_user}
  [, <userlist> ...]
  [WITH GRANT OPTION]
<role_granted> = rolename [, rolename ...]
<role_grantee_list> = [USER] username [, [USER] username ...] [WITH ADMIN OPTION]

    对于REVOKE：

    REVOKE [GRANT OPTION FOR] <privileges> ON [TABLE]
          {tablename | viewname}
       FROM {<object> | <userlist> | <rolelist> | GROUP UNIX_group}
   | EXECUTE ON PROCEDURE procname
       FROM {<object> | <userlist>}
   | <role_granted> FROM {PUBLIC | <role_grantee_list>}};
<privileges> = {ALL [PRIVILEGES] | <privilege_list>} <privilege_list> = {
SELECT
   | DELETE
   | INSERT
   | UPDATE [(col [, col ...])]
   | REFERENCES [(col [, col ...])] [, <privilege_list> ...]}}
<object> ={
   PROCEDURE procname
   | TRIGGER trigname
   | VIEW viewname
   | PUBLIC
   [, <object>]}
<userlist> = [USER] username [, [USER] username ...]
<rolelist> = rolename [, rolename]
<role_granted> = rolename [, rolename ...]
<role_grantee_list> = [USER] username [, [USER] username ...]

    Firebird 文档曾经在原始的 Interbase 6 文档和语言参考更新中被分散，该更新仅描述了较新版本中引入的更改。

    但是现在有一个完整的Firebird 2.5 语言参考。

    • 1

相关问题