Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 64 bit or 32 bit?

64 bit or 32 bit?

From: Gregory Faktor <gfaktor_at_ecal.com>
Date: Wed, 16 Aug 2000 10:24:55 -0400
Message-Id: <10591.114727@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US