Wednesday, May 06, 2009

Oracle : Create User

example:create sample2_clean
at Aqua application:

--create user
Create user sample2_clean identified by password
go
--grant access
grant connect to sample2_clean
go
grant resource to sample2_clean
go
grant create any snapshot to sample2_clean
go
grant sysdba to sample2_clean
go

No comments: