Oracle Create users, grant permissions, and delete users 1

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.