Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JossT
Starting Member
1 Post |
 Posted - 2010-03-05 : 02:27:52
|
| Hi,I have installed MSSQL 2005 Express edition on Windows 2003 Server. After creating a user with dbowner permission I am able to see All the database in magement studio and also able to see some of database tables (Can read the data but not able to modify). Please help me how I can resolve both the issues.dbowner user will not able to see any other database tablesordbowner user will able to see only his database in management studio.Thanks. |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-05 : 16:32:56
|
| Joss,Understand the security on proper way. dbowner can do any thing on the particluar DB. Why cant you create a new ROLE and assign (read + write + ddl admin ) individual roles and REVOKE permissions on the objects whatever USER is not suppose see ....With RegardsSR |
 |
|
|
|
|
|
Database permission Issue.