Ralf Schneider wrote : >Gesendet: Freitag, 14. Oktober 2005 10:43 >An: [email protected] >Betreff: Cannot create View as STANDARD user > > >Hi, > >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 > >The reference manual says that a STANDARD user can create >views, synonyms and >temporary tables. What is the problem? > >I user MaxDB 7.5.0.19 on Linux (SuSE 10.0 with kernel 2.6.13). > >Best regards, >Ralf. > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > >
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). Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
