we didn't grant connect, resource roles to users.
So we revoked connect, resource from users
before we did,
we created new role, example
>create role rb_user1;
and grant some privileges
> grant create session,alter session to rb_user1;
after we granted rb_user1 role to all users.
>grant rb_user1 to test;
Tuesday, March 14, 2006
Subscribe to:
Post Comments (Atom)
Posts
1 comment:
when we revoked connect, resource , i found some problems
user no quota each tablespaces, so can't insert data to some tables
So we checked
select * from dba_ts_quotas;
and check
select owner,table_name, tablespace_name from dba_tables;
and
select owner,index_name, tablespace_name from dba_indexes;
after
alter user test quota unlimited on tablespace_name;
Post a Comment