Ralf Schneider wrote : >Gesendet: Freitag, 14. Oktober 2005 11:20 >An: Anhaus, Thomas >Cc: [email protected] >Betreff: Re: AW: Cannot create View as STANDARD user > > >Am Freitag 14 Oktober 2005 11:07 schrieb Anhaus, Thomas: >> >I try to create a view as a user of type STANDARD, but I >get the error >> >message: >> > >> >Syntax error or access violation;-5001 POS(35) Missing >> >privilege:ROLE DEFINED >> >PRIVILEGE >> >> This has nothing to do with the standard user. >> The problem is that you got granted some required privileges >via a role. >> Roles are not considered by data definition statements (like >create view >> statement). > >That's right, the user has been granted some privileges via a >role. But how do >I have to change my database design to be able to create a >view as this user? > >Best regards, >Ralf. >
If you want the standard user to create the view, you have to grant the required privileges directly to him. Otherwise you could create the view by another user in another schema and grant that view to the standard user. Best regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
