Shulou(Shulou.com)06/01 Report--

-- create tablespaces

Create tablespace test_tps

Datafile'D:\ app\ Administrator\ oradata\ orcl\ test_tps.dbf'

Size 1500M

Autoextend on next 5M

-- create users and develop tablespaces

Create user test_tps identified by test_tps

Default tablespace test_tps

-- Grant permissions

Grant connect,resource to test_tps

Grant create any sequence to test_tps

Grant create any table to test_tps

Grant delete any table to test_tps

Grant insert any table to test_tps

Grant select any table to test_tps

Grant unlimited tablespace to test_tps

Grant execute any procedure to test_tps

Grant update any table to test_tps

Grant create any view to test_tps

-- empowered DBA

Grant sysdba to test_tps

-- revoke dba permissions

Revoke dba from user

-Authorization commands:

-- GRANT {DBA | RESOURCE | CONNECT} TO {PUBLIC | user-list}

-- PUBLIC | user-list: all or specified users.

-- only one of the three permissions, do not execute GRANT statements during transactions.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.