Newsgroups: comp.databases.oracle From: ccshf@midge.bath.ac.uk (Henry Ford) Subject: OPS$ in Oracle6 Message-ID: Organization: Bath University Computing Services, UK Date: Tue, 14 Dec 1993 13:44:50 GMT Lines: 16 I have started to use the OPS$ technique to add users to the ORACLE6 system and have run into a problem. Part of my forms system calls a .sql file to construct another sql file and run it. The username is selected from sys.dual for identification purposes and is passed to the file with the &1 parameter e.g. 'select '||'''&1'''||', etc. This was fine until I tried the OPS$username, when all that gets passed is OPS. So far I have failed to get the username passed, or even OPS$username, which would be sufficient for identification. Any help from out there would be gratefully acknowledged !