Oracle create user, grant permissions, and delete user create user Oracle to tablespace users without permission alter user username quota unlimited on users;
Creating a temporary tablespace create temporary tablespace test_temp tempfile ' E:/oracle/product/10.2.0/oradata/testserver/test_ temp01.dbf ' size 32m autoextend on next 32m maxsize 2048m extent management local; Creating a data table space create tablespace test_data logging www.2cto.com datafile ' e:/oracle/product/10.2.0/oradata/testserver/test _data01.dbf ' size 32m autoextend on next 32m maxsize 2048m extent management local; Create user and specify table space create user username identified by password default tablespace test_data temporary tablespace test_temp; Delete user drop username cascade;---cascade cascade//Grant user permission Grant Connect,resource to username;//later log on as that user, any database objects created belong to Test_temp and Test_data table space, which is not
The table space is specified for each object that is created. www.2cto.com Grant Permissions--Assign user Sam create TABLE, create sequence, create stored procedure and CREATE VIEW permissions grant Create Table,create sequence,create view, Create Procedureto sam l Remove user rights --Remove user Sam permissions to create a view revoke creation view from Sam; l assigning role permissions --assigning roles Manag Er Create a table, create a sequence of permissions grant create table,create sequence to manager; l remove user Rights --Remove Role Manager permissions to create view revoke creating table Select permission for the From Manager; l allocation table to the user --assign user sam on the table TT on the SELECT permission grant SELECT on the TT to sam;--remove the user Sam on the table TT SE Lect permissions Revoke select on the TT from SAM; L assign table update permissions to roles www.2cto.com --Assign table update permissions to roles Managergrant upd Ate on the TT to manager;--remove the update permissions for the table to the role Managerrevoke update on the TT from MANAGER; L assign table SELECT permission to all Users --allocation table S Elect permissions to all users grant select on the TT to public;--removes the SELECT permission for the table to all users revoke select on the TT from PUBLIC; L allocation table to the user, and allows He authorizes the other person to --the SELECT permission of the allocation table to the user Sam, and allows the SELECT permission of the Sam strike to be granted to others grant select on the TT to Sam with GRANT option;
Oracle creates users, grants permissions, and deletes users 1
