search

JoeyAlvarez / Vote

0 stars 0 forks source link

Change default schema for mydbr user #3

Closed JoeyAlvarez closed 3 weeks ago

JoeyAlvarez commented 3 weeks ago

Make the default schema for the mydbr user the "vote" schema on the database "Vote"

USE yourDatabase; ALTER USER [yourUser] WITH DEFAULT_SCHEMA = myschema;

JoeyAlvarez commented 3 weeks ago

You can mark this as won't do because its impossible without changing the permissions.

Antnknee commented 3 weeks ago

Attempted default schema change, was not possible.