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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-27 : 09:07:52
|
| Analia writes "How could I create a table with an user that is not the "sa" and that is this visible for the remainder of the Users? I at the present time have an user with privilege of dbowner that creates tables in time of execution but the remainder of the user doesn't view, but they have been assigned a functions o groups with permission of SELECT, UPDATE, INSERT And DELETE on these tables." |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-09-27 : 12:11:59
|
| For all users you use PublicGrant select,update, Insert,delete ON YOURTABLE to publicJimUsers <> Logic |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-09-27 : 14:25:45
|
| though he has the dbowner role, it's probably the case that the objects are being created as his.Ie jqpublic.tablename instead of dbo.tablenamedbo tables are globally viewable to public by default. Individual user tables are only viewable if the other users prefix the object with the owner name.So, have the dbowner user create his objects using:"create table dbo.tablename..."instead of just "create table tablename" |
|
|
|
|
|
|
Tables and Security