Stack Overflow
Stack Overflow

Questions tagged [dbo]

Use dbo for questions related to SQL Server database ownership of tables, catalogs, schema, or other database objects

References

70 questions
1
vote
2 answers

Create an database user/role that has the permission to grant on dbo schema

I have some stored procs under schema dbo. I also database level role: Tech, and a database level user: Jack. Jack is a member of Tech. As sa I am able to run: GRANT EXEC ON SCHEMA :: dbo TO Tech Then Jack would have EXEC permissions to all…
San Zhang
  • 155
  • 2
  • 9
1
vote
1 answer

How to implement a for each loop in SQL

How to implement a for each loop in SQL? I am looking for a way to automate the backing up of databases for SQL Server 2019 to a given folder, with the following name syntax: I am hoping to be able to a list of all databases in a…
Guilder
  • 444
  • 4
  • 12
1
vote
3 answers

How to change the owner of a SQL Server table from domain\username to dbo?

When I create a table, the owner is always domain\username instead of dbo. For example, domain\username.tablename I know how how to change it to dbo but what should I change in the configuration level to make sure that when I create a table, the…
Joie Tamayo
  • 501
  • 3
  • 8
  • 21
1
vote
2 answers

Creating tables and queries with dbo as owner on a shared SQL Server?

I'm developing a database that would eventually live on a shared SQL Server 2008 database on the host machine (at hosting provider). I noticed that all the tables and queries are owned by the dbo. I would like to know if this is a security issue…
Sivakanesh
  • 817
  • 4
  • 13
  • 36
1
vote
1 answer

Why i cannot set my db table with a code one by one in php?

Hi guys i was trying whole my week to solve this problem. I want to set my tables "isim" column with array. But the bot fills this column with array[1] in all rows. I want to set each row with each element of array but its filled with the same…
Tarık Baysal
  • 41
  • 1
  • 5
1
vote
1 answer

DBO Select where equals and like

I have tried writing the code below 100 different ways and cannot figure out the proper syntax. It seems no matter how I write this, the $loggeduser is not passed to the WHERE username. What am I doing wrong? What is the proper syntax? $query =…
Bruce
  • 1,039
  • 1
  • 9
  • 31
1
vote
1 answer

How can I save a new Stored Procedure to the database I'm working with in Server Explorer?

In Server Explorer (within Visual Studio) I can expand a database, right click on the Stored Procedures folder, and select "Add New Stored Procedure" I can then add an SP and try to execute it. However, when I try to save the Stored Procedure (so…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1
vote
1 answer

Wt Segfault on ORM Transaction Commit

http://www.webtoolkit.eu/wt/doc/tutorial/dbo.html says The complete source code for the examples used in this tutorial are available as ready-to-run programs in the examples/feature/dbo/ folder of Wt. I'm trying to run tutorial1.C from that…
lmat - Reinstate Monica
  • 7,289
  • 6
  • 48
  • 62
1
vote
6 answers

What harm can DBO do to a server?

Aside from executing XP_CmdShell, which I have disabled in my SQL 2005 installation, what could a malicious user who gains DBO rights to my database do: To my database, To my server? I'm assessing the worst-case security risk of someone obtaining…
Caveatrob
  • 12,667
  • 32
  • 107
  • 187
1
vote
4 answers

Can't update from NULL to 0

Hi i'm using this command to left join a table with another table that has a little more records but it keep printing NULL. I want that NULL to become 0. SELECT * FROM TABLE1 Left JOIN Table2 ON TABLE1.ID=Table2.IDRel UPDATE Table2 SET IDRel = 0…
Didy
  • 85
  • 1
  • 2
  • 8
1
vote
1 answer

Alias column in new Drupal7 database API

I'm working through my queries, changing them over to the new API. I'm trying to SELECT an alias that includes as CASE statement. Here is my original SQL: SUM(CASE MONTH(data.start) WHEN 1 THEN data.accepted END) AS 'Jan', And this is what I'm…
Boomfelled
  • 515
  • 5
  • 14
1
vote
2 answers

Composite Key on a Self Referencing Table

We have a composite primary key for the site table defined below. Functionally, this does exactly as we would like it to. Each site should have a parent site of the same district. Defining the table in this way allows specifically for that. …
LJM
  • 6,284
  • 7
  • 28
  • 30
1
vote
2 answers

SQL Server 2000 - Programmatically Limit Access to Database Owner?

How would I programmatically go about limiting the access of a database in SQL Server 2000 to the database owner for that database? Example... if I right-click "Properties" on the "Northwind" database in Enterprise Manager, the Owner is listed as…
Donut
  • 110,061
  • 20
  • 134
  • 146
0
votes
0 answers

Django - Default schema (dbo) to custom schema name for native django apps?

I would like django to change the reference to the native django table(s) schema(dbo) as seen in the sql below. I have renamed the schema to meta in SQL, but when I run the app, it recreates the tables on the dbo schema again in the DB. So I deleted…
Farrel
  • 185
  • 1
  • 10
0
votes
1 answer

Dapper: Not able to parse Date from dbf(Error parsing column)

I want to use dapper to query over dbf files. In my file example.dbf I have 7 columns: Version- string CreatedOn- Datetime Features- string CreatedBy- long ModifiedOn- Datetime ModifiedBy- long IsDeprecated- bool public class ExampleDBF :…
Sai
  • 3
  • 2
1
2
3 4 5