Re: how to stop user from altering schema

Or in other words, you cannot restrict an ower's access to their own objects unless you can prevent the owner from logging on.

Generally you create objects under one id then issue object privileges to a role and grant the role to the user(s) that need the object privileges but the role does not include any DDL privileges. Access to the owner id is restricted to DBA and/or a few key people.

HTH -- Mark D Powell -- Received on Thu Jun 09 2005 - 10:19:19 CDT