Re: Who is Who ??

Try to create a diagram after....
EXEC sp_dbcmptlevel 'DBname', '90';goALTER AUTHORIZATION ON DATABASE::DBname
TO "rptUser"gouse DBnamegoEXECUTE AS USER = N'dbo' REVERTgo"calderara"
<calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:55FFEDC6-84AD-4E14-A018-6E4B7675B866@xxxxxxxxxxxxxxxx
HI,

I follow you steps a create a new user under mydatabase security as
NewUser
and mappe it to rptUser login type.

So far so good..

I am then logged on my server with BuildTIN\Administrator or "sa" whatever
I
select. Then selecting the "Database Diagrams" folder of my database I get
following message :

"Database diagram support objects cannot be installed because this
database does not have a valid owner.To continue, first use the Files
page of the Database Properties dialog box or the ALTER AUTHORIZATION
statement to set the database owner to a valid login,
then add the database diagram support objects.
"

Then I slect the first option to veriofy the File and Databse owner is set
to "sa"

Then if I try to change it to rptUser I get following message :

"The proposed new database owner rptUser is mapped as user Line in this
database.
Parameter name: rptUser"

In fact I just wonder if the fact I am not able to go inside the Database
diagram could affect my database setup or can I just ignore it if I am not
using it ?


"Uri Dimant" wrote:

Hi
In SQL Server 2005 MS has introduced a new concept called SCHEMA , it
is a
huge subkect I'd suggest to spend a few days to study it

Now, navigate to the database and click on Security folder and then
Users.
Identify rtUser and doubl click , do you see that the user is mapped to
the
"right" Login

Also check out that all objects have DBO schema.

I did just some testing and it worked fine
1) BACKUP sql server 2000 database and restore on SQL Server 2005 (owner
of
the db is 'sa')
2) Create a new Login and a new user mapped to the login
3) Grant access to the objects to the new created user
4) Login as SA and created diagram succefuly




"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AEEECD9C-8C4D-4903-89D4-C8D8BA85D98C@xxxxxxxxxxxxxxxx

I forgot to mention.. yes I can connect without trouble to database and
transfert data. BUt I was wondering if it is the right way to do.

What is the real difference with login user at the server level and
User
define as database level ?

Becasue when you define a new user for the database you need to enter a
name
and then you have a selection item named "Login" which point actualy to
my
rptuser

Why I cam in all those question is that I am not able to go or activate
inside database design function and return error mentionned earlier in
discussion

thnaks for help
"Uri Dimant" wrote:

Caldera

Can you drop rptUser in the database? Then create a new rptUser to
be
mapped to the login that you have on the server.
Try connect thru the application to the database.


"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3AB2D800-9184-42FE-BEFC-4ABE0C8096FD@xxxxxxxxxxxxxxxx

HI russel,

Here is how my server security is set :

On my server security folder I have login users :
===============================
"sa" pointing to master db
"rptUser" pointing to MyDatabase

rptUser is the single account used in connection string to connect
to
my
server

On Mydatabase security folder I have :
=========================
- defined a user named PSULINE which is used the "rptUser" Login
name
This user as the db_owner right in addition to db_datareader and
db_datawritter
I ma using then that "PSULINE" user to set rights on tables

If I try to change the owner of myDatabase from the Files item in
Database
propertie dialog to be "rptUser" instead of "sa", it says that it
caannot
because rptUser is mapped as user PSULINE...

What did I set wrong ?
Do I have to define 2 users ?

thnaks
serge
"Russell Fields" wrote:

serge,

Look at database security and see who is mapped to the dbo
internally
to
the
database. It may be that the internal dbo login is not "sa" but
something
else. This is common in restores from other installations.

If that is the case, master database believes that "sa" is the
owner
and
the
database believes that "somebodyelse" is the owner. Use
sp_changedbowner
to
set the database owner. (If you are on an older release, you might
have
to
set the owner to "another" account, then back to "sa".)

RLF
"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF72A3E2-BFE7-4CED-A71C-ECC64881EB06@xxxxxxxxxxxxxxxx

Thnaks for your reply russel,

I run the system store procedure sys.help_db and the owner for
the
database
I am interresting on is set to "sa".

Yes I have restore that database from a previous customer as I am
going
to
use exactly teh same for an other.

Do I have to change anything in order to get something clean ?

thnaks for help
regards
serge

"Russell Fields" wrote:

Serge,

If you run sp_helpdb, who does it say owns the database? Is it
an
unexpected owner, such as can happen when a different account
restores
a
database?

RLF

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:8DBC4605-D2A2-4B00-9DE9-5C56BC229473@xxxxxxxxxxxxxxxx
Dear all,

I have setup database on my SQL server 2005.
I am accessing to that database with a connection string using
a
single
account named rptUser with SQL authentication.

My SQL server has been configured for mix mode.
Once my databse has been created I ma able to remotely access
it
and
store
data without any trouble.

It means that I have define a login user rpUser for my server
and
then
defined proper rights on tables.

Then I am lgged in on my OS server as administrator user.
I have noticed that if I try to enter the Design diagram I get
a
messaying
saying that I am not able to perform this opetration becasue
teh
database
has
an invalid owner ??

Then if I check about the effective permission of my rptUSer,
it
has
the
ownser flag ??

What to chek then or what to do to be able to enter this
design
diagram.
I have only this rptUser define for my database and SQL login
in
addintion
to the "sa"

thnaks for help
regards
serge














.

Relevant Pages

  • Re: Who is Who ??
    ... and mappe it to rptUser login type. ... I am then logged on my server with BuildTIN\Administrator or "sa" whatever I ... Then selecting the "Database Diagrams" folder of my database I get ... Then if I try to change it to rptUser I get following message: ...
    (microsoft.public.sqlserver.security)
  • Re: Who is Who ??
    ... On my server security folder I have login users: ... "rptUser" pointing to MyDatabase ... If I try to change the owner of myDatabase from the Files item in Database ...
    (microsoft.public.sqlserver.security)
  • Re: Who is Who ??
    ... connection string "rptUser" as SQL authentification as I do not need to track ... Does the single user used for the connection string can be used for login ... mapped to the login that you have on the server. ... Try connect thru the application to the database. ...
    (microsoft.public.sqlserver.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)