I want to create a table that has denies all select, update, delete
access for all users except the owner of the table. This isn't really
hard to do, however what I'm trying to accomplish is that access is
also denied from the SQL Server Manager, meaning the dbo must also be
denied.
Is this possible? I've tried to deny select access for the object on
the dbo, however this doesn't do anything...
Re: ADP: Cant use stored procedure on remote SQL server ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure.... (microsoft.public.access.adp.sqlserver)
Re: rda push when owner is not dbo. ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ... (microsoft.public.sqlserver.ce)
Re: Question about dropping owners permissions... ... When a member of the db_owner role creates an object, ...dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ... (microsoft.public.sqlserver.security)
Re: User names ... I don't have a pre-sp3 server to try this on, but in sp3, if you are a user ... byjust specifically giving the owner name in QA. ... > dbo was the owner. ... (microsoft.public.sqlserver.server)
Re: not creating tables as dbo anymore ? ...Database Owner (dbo)... existing user ID in the database specified by database_name. ... with the login of the current connection. ... (microsoft.public.sqlserver.security)
