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. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
