Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create schema without a user?
Kenny,
Thanks. That's what I was after.
Kenny Gump wrote:
> You can create a user account and not give it 'create session' privilege.
> Then to create a table in that schema you will need 'create any table'
> privilege. This is the prefered method for production tables any way.
>
> Kenny Gump
> OCP 7.3 DBA
> ---------------------
> Ken Rachynski wrote in message <36DB20F7.6852631F_at_cadvision.com>...
> >Good day,
> >
> >I was wondering if it was at all possible to create a schema without
> >having a user account for that schema.
> >
> >--
> >Ken Rachynski
> >Database Analyst
> >krachyn_at_cadvision.com
> ><http://www.cadvision.com/krachyn>
> >ICQ: 3113514
> >
> >
--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514
Received on Tue Mar 02 1999 - 10:00:51 CST
![]() |
![]() |