On 07/23/14 12:03, Gabor Boros wrote: > Hi, > > If I want to initialize security database "gsec -add SYSDBA -pw > masterkey" on Win32 got error with snapshot from today 31247. With > earlier used 31159 works like a charm. > > "An error occurred while attempting to add the user. > unsuccessful metadata update > CREATE TABLE PLG$SRP failed > There is no privilege for this operation"
After adding DDL privileges only DBO by default can create objects in database. But w/o -user switch you connect as windows user. I.e. you should become sysdba in gsec. In embedded connection (used when initializing sec db) it's very easy: gsec -user SYSDBA -pas anytext -add SYSDBA -pw masterkey Switch -pas is needed because gsec itself ignores -user without -pas (this will be fixed soon). Alternative: isql -user SYSDBA employee SQL> create user sysdba password ' masterkey'; ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
