A为了授予B创建表的权限，应该具有什么权限？
以用户身份登录A，我执行
grant create table to B;
并收到以下错误：
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.
看起来您正试图将一个模式授予另一个模式的权限。Oracle中不存在这样的事情，但是有解决方法。
实现这一点的最简单方法是将 CREATE ANY TABLE 权限授予 B，但这样做存在明显的安全问题。