Last post Jan 05, 2015 05:26 AM by Revathi Velu
Dec 29, 2014 06:44 AM|Uma Mahesh|LINK
Am Creating A Sql Login Name As 'WishesLogin'
Giving the permissions : Reading,Writing Permissions On Login Creation
then Am login into ssms and try to create table getting error like
" you are not logged as the data base owner (or) you might not to save changes to tables
Dec 29, 2014 08:20 AM|Ken Tucker|LINK
I think the user has to be a database owner to create a table. Just make the user a database owner
Jan 05, 2015 05:26 AM|Revathi Velu|LINK
login the database in sql server authentication
click on object explorer on the left side.
expand security,expand logins,double click on the user you want to give permission,
a new window will open.click on user mappind on the left side.
check the database you want to give permission and then click on db_ownner which is in the same window on click ok.
so this way the user has all right to access that database.