Re: Who is Who ??
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 28 Feb 2007 10:14:33 +0200
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
.
- Follow-Ups:
- Re: Who is Who ??
- From: calderara
- Re: Who is Who ??
- References:
- Re: Who is Who ??
- From: Russell Fields
- Re: Who is Who ??
- From: Russell Fields
- Re: Who is Who ??
- From: calderara
- Re: Who is Who ??
- From: Uri Dimant
- Re: Who is Who ??
- From: calderara
- Re: Who is Who ??
- Prev by Date: Re: Who is Who ??
- Next by Date: Re: Who is Who ??
- Previous by thread: Re: Who is Who ??
- Next by thread: Re: Who is Who ??
- Index(es):
Relevant Pages
|
|
