CREATE USER WEBPF IDENTIFIED BY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT / GRANT CONNECT TO WEBPF WITH ADMIN OPTION / GRANT DBA TO WEBPF WITH ADMIN OPTION / GRANT RESOURCE TO WEBPF WITH ADMIN OPTION / GRANT UNLIMITED TABLESPACE TO WEBPF WITH ADMIN OPTION / 这样创建的如何?
你看,你已经把DBA权限赋予了userGRANT RESOURCE TO WEBPF WITH ADMIN OPTION /
你已经把DBA赋给USER用户了,那么就应该有了呀!你还要如何呀!如果想要没有那么把GRANT DBA TO WEBPF WITH ADMIN OPTION 这条语句去掉就可以了。
搞错了。是这一句。呵呵/ GRANT DBA TO WEBPF WITH ADMIN OPTION /
IDENTIFIED BY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO WEBPF WITH ADMIN OPTION
/
GRANT DBA TO WEBPF WITH ADMIN OPTION
/
GRANT RESOURCE TO WEBPF WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO WEBPF WITH ADMIN OPTION
/
这样创建的如何?
你看,你已经把DBA权限赋予了userGRANT RESOURCE TO WEBPF WITH ADMIN OPTION
/
这条语句去掉就可以了。
GRANT DBA TO WEBPF WITH ADMIN OPTION
/