Re: Who is Who ??
- From: calderara <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 27 Feb 2007 22:14:12 -0800
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: Uri Dimant
- Re: Who is Who ??
- References:
- Re: Who is Who ??
- From: Russell Fields
- Re: Who is Who ??
- From: Russell Fields
- Re: Who is Who ??
- Prev by Date: Re: Backup
- 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
|
|
