--创建用户user1,密码123,缺省表空间:users,temp表空间temp create user user1 identified by "123" default tablespace users temporary tablespace temp quota unlimited on users; --授权 grant connect to kdczhp;
--创建用户user1,密码123,缺省表空间:users,temp表空间temp create user user1 identified by "123" default tablespace users temporary tablespace temp quota unlimited on users; --授权 grant connect to user1;
create user your_test identified by pwd; grant create session to your_test; 以上这些授权保证用户可以进行登陆,然后你可以根据需要对这个用户授予访问某个对象的权限,这样这个用户就只能访问你所授权的对象了
create user user1 identified by "123"
default tablespace users
temporary tablespace temp
quota unlimited on users;
--授权
grant connect to kdczhp;
create user user1 identified by "123"
default tablespace users
temporary tablespace temp
quota unlimited on users;
--授权
grant connect to user1;
grant create session to your_test;
以上这些授权保证用户可以进行登陆,然后你可以根据需要对这个用户授予访问某个对象的权限,这样这个用户就只能访问你所授权的对象了