Re: How to get version of server connected to without sys authority?

Hi Michel,

You are correct on 9iR2 as my check script shows:

who_can_access: Release 1.0.0.0.0 - Production on Thu Mar 11 15:13:36 2004
Copyright (c) 2004 PeteFinnigan.com Limited. All rights reserved.

get user input

NAME OF OBJECT TO CHECK [USER_OBJECTS]: v_$version
OWNER OF THE OBJECT TO CHECK    [USER]: sys
OUTPUT METHOD Screen/File          [S]: 
FILE NAME FOR OUTPUT        [priv.lst]: 
OUTPUT DIRECTORY                [/tmp]: 

Checking object => SYS.V_$VERSION

Object type is => VIEW (TAB)

        Privilege => SELECT is granted to =>
                Role => PUBLIC

PL/SQL procedure successfully completed.

For updates please visit http://www.petefinnigan.com/tools.htm

SQL>

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.