Re: user permissions

yes, he's dbo but it seems that he cannot make this kind of operations...


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:Oi0VaiqgIHA.2004@xxxxxxxxxxxxxxxxxxxxxxx
Hi
Is she/he an owner of db? db_owner role.





"Trapulo" <trapulo2@xxxxxxxxxxxxxxx> wrote in message
news:eur9$tpgIHA.6092@xxxxxxxxxxxxxxxxxxxxxxx
How can I allow a user to see single database size, and kill process on
that DB, without make it "sysadmin", on SQL 2005?

thanks






.

Relevant Pages

  • 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: db_owner role in SQL 2k
    ... Role membership doesn't affect the owner of an object. ... power to create objects owned by other users, including owned by dbo. ... SQL Server MVP ... "John" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • SQLCE Push pb on VB.Net Compact Framework
    ... I'm using RDA to sync the ce db with a sql server db. ... I have SQL Server tables with "dbo" owner and some have specific owner. ... The tables with owner "dbo" are sync with no pb - the pull and the push ...
    (microsoft.public.sqlserver.programming)
  • Re: User names
    ... a dbo or sa it will use dbo as the owner. ... Andrew J. Kelly SQL MVP "Laura K" wrote in message ... > The issue was resolved by installing SP3 for SQL server. ...
    (microsoft.public.sqlserver.server)
  • RE: dbo/owner
    ... The only way the users can create procedures with dbo as the owner is to be ... a member of the db_owner role (or sysadmin). ...
    (microsoft.public.sqlserver.security)