Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 64 bit or 32 bit?
Hi All!
How I could find out what Oracle version installed on SunOS: 64 bit or 32
bit?
Thanks.
Greg.
From: Lyall Barbour <lbarbour_at_stanford.edu>
Date: Wed, 16 Aug 2000 07:53:12 -0700
Subject: Re: Minimal privileges to create a table
Huh, OK.
At 08:03 PM 8/15/00 -0800, you wrote:
>resource has ALWAYS given you unlimited tablespace...
>
>do not check the privs assigned to the role. Check the privs assigned
>directly to the user. See below, run in my 7.3.4 database.
>
>Rachel
>
>SQL> create user resource_test identified by test
> 2 default tablespace users
> 3 temporary tablespace temp;
>
>User created.
>
>SQL> select grantee,privilege from dba_sys_privs where
>grantee='RESOURCE_TEST';
>
>no rows selected
>
>SQL> select grantee,privilege from dba_sys_privs where grantee='RESOURCE';
>
>GRANTEE PRIVILEGE
>--------------- ------------------------------
>RESOURCE CREATE CLUSTER
>RESOURCE CREATE PROCEDURE
>RESOURCE CREATE SEQUENCE
>RESOURCE CREATE TABLE
>RESOURCE CREATE TRIGGER
>
>SQL> grant resource to resource_test;
>
>Grant succeeded.
>
>SQL> select grantee,privilege from dba_sys_privs where
>grantee='RESOURCE_TEST';
>
>GRANTEE PRIVILEGE
>--------------- ------------------------------
>RESOURCE_TEST UNLIMITED TABLESPACE
>
>
>>From: Lyall Barbour <lbarbour_at_stanford.edu>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: Re: Minimal privileges to create a table
>>Date: Tue, 15 Aug 2000 15:35:04 -0800
Received on Wed Aug 16 2000 - 09:24:55 CDT