sys.tables with custom user

Roberto I'm unable to repeat your tables problem with a custom user. Did you by any change not use the sys. prefix? As a custom user with its own default schema will not be in the sys schema you need to add this. This doesn't hold for the _tables as thats found in the 'tmp' schema. Temp tables are always visable. Niels -- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl