I am having a problem understanding the db users.
I am working on a DNN site, and having troubles with db users permissions.
I want to know what is the DBO?
I have a user in my database, that is assigned "public".
In my application usually, what should i do:
1- Login with the public user, create tables, views, sp, add data ...
2- Use the dbo always?
In my application, I will be using the public user in the connections string.
Can you help please.
DBO is the db owner.
In DNN, the user should have DBO privileges in order to create/delete/move data.
HTH
|||Thanks, but your answer is not well explained.Can you explain to me more please? I need more information to understand well.
thanks|||
There are two permissions in SQL Server, the Server permissions in the Security section of Enterprise Manager and the database permissions in the database. What you want to know is roles because DBO is database owner role which is assigned to the owner of the database and the server System Admin is also DBO by default. Then there is public role which every user of the SQL Server belong and cannot be dropped. Try the link below for more info. Hope this helps.
http://www.databasejournal.com/features/mssql/article.php/1441261
No comments:
Post a Comment