why can I not create a stored object using privileges from a role
From: <steve.clover_at_syntex.com>
Date: Thu, 29 Sep 94 14:34:34 PDT
Message-ID: <36efvr$7vm_at_yoda.Syntex.Com>
Date: Thu, 29 Sep 94 14:34:34 PDT
Message-ID: <36efvr$7vm_at_yoda.Syntex.Com>
I am curious...
For example if we grant select any table to a role and grant that role to a user, that user cannot create a
view based on a SYS table. You get ORA-01993
Cheers,
Does anybody know the reason why you cannot create a stored object using privileges from a role.
Steve Clover
Syntex Development Research, Maidenhead, Berkshire, England.
Received on Thu Sep 29 1994 - 22:34:34 CET