Post reply

Dbcreator sql server role

  • November 22, 2011 at 1:17 am

    #246641

    Hi

    Today i have created database by xyz user by assigning the dbcreator sql server role but question that if check the current database ldf file in ssms it is not showing where ldf file is located and i checked using the sp_helpdb for my database "sg 15010, Level 16, State 1, Procedure sp_helpdb, Line 44

    The database 'bdkjk' does not exist. Supply a valid database name. To see available databases, use sys.databases". So why the ssms is not showing the ldf file and how i can increase size of log file by using ssms .please help this top me

    Vivek

  • November 22, 2011 at 5:03 am

    #1411357

    hi

    dbcreator have only permission to create new database on the instance, if you want alter the database to add the file, u need db_owner of alter database permission on the particular db

    regards

    kk

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply