Skip to content

bootstrapping DB for each user #2

@degaurab

Description

@degaurab

Step taken right now:

  • Create database for user:

     queryString := fmt.Sprintf("CREATE DATABASE %s", dbname)
    
  • Create user:

    queryString = fmt.Sprintf("CREATE USER %s with encrypted password '%s'", n.UserName, n.Password)
    
    
  • Grant privileges to user:

    queryString = fmt.Sprintf(	"GRANT ALL PRIVILEGES ON DATABASE %s TO %s", n.DBName, n.UserName)
    
    

But I am guessing this are not sufficent enough to create isolation in shared DB.
Would be nice to get additional bootstrapping details.

cc: @doty-pivotal

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions