How to give Object permission Oracle 10G XE via CMD line

[eduardo.d2]

Environment information:
* Oracle version: 10g Express editio
* Operating system: XP

Hello everyone, I would like to know how I can give permission to the object, in my schema?

I created a user and would like to give permission to create tables, proc, pkg, fuction etc
I sailed after that on the net and I did not find anything specific about it, I found yes to Permission to delete system, update insert

could help me with this already my thank you

[elidias7]

Good afternoon,

You can grant these types of permissions through SQLPLUS.

See more information regarding the Grants of Objects in the document below
http://download.oracle.com/docs/cd/B193 ... SQLRF01603
Hugs,

[eduardo.d2]

vlw elidias7,
I did a small script for this

--- creating user in schema sysdba

Select all

CREATE USER TESTE 
IDENTIFIED BY TESTE 
DEFAULT TABLESPACE USERS 
TEMPORARY TABLESPACE TEMP 
PROFILE DEFAULT  
PASSWORD EXPIRE  
ACCOUNT Lock

99]] - giving permissions to the User Study

Select all

GRANT CREATE TABLE TO ESCOLA; 
GRANT CREATE MATERIALIZED VIEW TO ESCOLA; 
GRANT CREATE  VIEW TO ESCOLA; 
GRANT CREATE  SESSION TO ESCOLA; 
GRANT DEBUG CONNECT SESSION TO ESCOLA; 
GRANT CREATE DATABASE LINK ESCOLA; 
GRANT CREATE ANY PROCEDURE TO ESCOLA; 
GRANT ALTER DATABASE TO ESCOLA; 
 
 
GRANT CONNECT, RESOURCE TO ESCOLA

- VERNEOD Permission

Select all

select * from dba_sys_privs where grantee = 'ESCOLA';