I can't access a number of tables on my SQL Server 7.0 database. Have checked using Enterprise Manager and the table does not appear to have any owner. When trying to do anything with the table I always get the following message
{SQL-DMO} The name 'Table Name' was not found in the tables collection. If the name is a qualified name, use [] to seperate various parts of the name, and the try again.
Have tried to change the owner by using sp_changeobjectowner but I am either getting the syntax wrong or it ain't working.
Any ideas??
c8lWhen you look in Enterprise Manager, what do you see?|||Hi,
The only thing I see is the table name (TABLE1), the type (USER) and the creation date. The owner column is blank. Normally you would expect it to say dbo.|||Blank?
What happends when you run this in QA?
SELECT * FROM INFORMATION_SCHEMA.Tables
Maybe you need to close EM and relaunch it. ...|||Thanks for the help but the problem has been resolved, I had to manually update the sysobject table so that the UID for each of the objects that could not be accessed was set to 1. For some reason this was 6.
Cheers
c8l
Showing posts with label owner. Show all posts
Showing posts with label owner. Show all posts
Thursday, March 22, 2012
Sunday, March 11, 2012
Cannot view DB properties
Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin rights
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:
> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:
> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:
> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:
> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:
> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:
> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Thursday, February 16, 2012
cannot see the view
Hi ,
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:
> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> > Hi ,
> >
> > I have created a login id on 2 different databases DB_A & DB_B as the
> > owner
> >
> > from crystal report i can see the view of DB_A but not DB_B using the
> > same
> > login id
> >
> > Could anyone kindly advise ?
> >
> > tks & rdgs
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>> Your post is not clear.
>> What is the default database for the login? Is Crystal connecting to
>> DB_A?
>> If so it will be able to see the view in that database. Unless you
>> "tell"
>> Crystal to look within DB_B for the view it will not be found.
>> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
>> TO
>> UserNameGoesHere
>> --
>> Keith
>>
>> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
>> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>> > Hi ,
>> >
>> > I have created a login id on 2 different databases DB_A & DB_B as the
>> > owner
>> >
>> > from crystal report i can see the view of DB_A but not DB_B using the
>> > same
>> > login id
>> >
>> > Could anyone kindly advise ?
>> >
>> > tks & rdgs
>>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:
> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> > Hi Keith ,
> >
> > the default db for the login is master. and i have set up 2 odbc
> > datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> > from crystal when connecting using DS_A it can show me the view but not
> > when
> > using DS_B
> >
> > i hope this time i am clearer in my explanation
> >
> > i'll try to use the grant select on the view for that login in DB_B
> >
> > tks & rdgs
> > "Keith Kratochvil" wrote:
> >
> >> Your post is not clear.
> >>
> >> What is the default database for the login? Is Crystal connecting to
> >> DB_A?
> >> If so it will be able to see the view in that database. Unless you
> >> "tell"
> >> Crystal to look within DB_B for the view it will not be found.
> >>
> >> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
> >> TO
> >> UserNameGoesHere
> >>
> >> --
> >> Keith
> >>
> >>
> >> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> >> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I have created a login id on 2 different databases DB_A & DB_B as the
> >> > owner
> >> >
> >> > from crystal report i can see the view of DB_A but not DB_B using the
> >> > same
> >> > login id
> >> >
> >> > Could anyone kindly advise ?
> >> >
> >> > tks & rdgs
> >>
> >>
> >>
>
>
I have created a login id on 2 different databases DB_A & DB_B as the owner
from crystal report i can see the view of DB_A but not DB_B using the same
login id
Could anyone kindly advise ?
tks & rdgsYour post is not clear.
What is the default database for the login? Is Crystal connecting to DB_A?
If so it will be able to see the view in that database. Unless you "tell"
Crystal to look within DB_B for the view it will not be found.
Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
UserNameGoesHere
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> Hi ,
> I have created a login id on 2 different databases DB_A & DB_B as the
> owner
> from crystal report i can see the view of DB_A but not DB_B using the
> same
> login id
> Could anyone kindly advise ?
> tks & rdgs|||Hi Keith ,
the default db for the login is master. and i have set up 2 odbc
datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
from crystal when connecting using DS_A it can show me the view but not when
using DS_B
i hope this time i am clearer in my explanation
i'll try to use the grant select on the view for that login in DB_B
tks & rdgs
"Keith Kratochvil" wrote:
> Your post is not clear.
> What is the default database for the login? Is Crystal connecting to DB_A?
> If so it will be able to see the view in that database. Unless you "tell"
> Crystal to look within DB_B for the view it will not be found.
> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere TO
> UserNameGoesHere
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> > Hi ,
> >
> > I have created a login id on 2 different databases DB_A & DB_B as the
> > owner
> >
> > from crystal report i can see the view of DB_A but not DB_B using the
> > same
> > login id
> >
> > Could anyone kindly advise ?
> >
> > tks & rdgs
>
>|||Does Crystal "know" that the other view exists within the other database?
Can you tell it to look in the other database for the view? Sorry, I have
not used Crystal since version 5.
--
Keith
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> Hi Keith ,
> the default db for the login is master. and i have set up 2 odbc
> datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> from crystal when connecting using DS_A it can show me the view but not
> when
> using DS_B
> i hope this time i am clearer in my explanation
> i'll try to use the grant select on the view for that login in DB_B
> tks & rdgs
> "Keith Kratochvil" wrote:
>> Your post is not clear.
>> What is the default database for the login? Is Crystal connecting to
>> DB_A?
>> If so it will be able to see the view in that database. Unless you
>> "tell"
>> Crystal to look within DB_B for the view it will not be found.
>> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
>> TO
>> UserNameGoesHere
>> --
>> Keith
>>
>> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
>> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
>> > Hi ,
>> >
>> > I have created a login id on 2 different databases DB_A & DB_B as the
>> > owner
>> >
>> > from crystal report i can see the view of DB_A but not DB_B using the
>> > same
>> > login id
>> >
>> > Could anyone kindly advise ?
>> >
>> > tks & rdgs
>>|||no worries Keith , tks for all the help given
Cheers,
maxzsim
"Keith Kratochvil" wrote:
> Does Crystal "know" that the other view exists within the other database?
> Can you tell it to look in the other database for the view? Sorry, I have
> not used Crystal since version 5.
> --
> Keith
>
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:A185A334-1164-44E5-A5EA-173A99FC669A@.microsoft.com...
> > Hi Keith ,
> >
> > the default db for the login is master. and i have set up 2 odbc
> > datasource DS_A & DS_B for connecting to DB_A and DB_B respectively
> > from crystal when connecting using DS_A it can show me the view but not
> > when
> > using DS_B
> >
> > i hope this time i am clearer in my explanation
> >
> > i'll try to use the grant select on the view for that login in DB_B
> >
> > tks & rdgs
> > "Keith Kratochvil" wrote:
> >
> >> Your post is not clear.
> >>
> >> What is the default database for the login? Is Crystal connecting to
> >> DB_A?
> >> If so it will be able to see the view in that database. Unless you
> >> "tell"
> >> Crystal to look within DB_B for the view it will not be found.
> >>
> >> Another possibility is that you need to GRANT SELECT ON ViewNameGoesHere
> >> TO
> >> UserNameGoesHere
> >>
> >> --
> >> Keith
> >>
> >>
> >> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> >> news:839BA81B-C1F6-4406-949B-40A686C1C69D@.microsoft.com...
> >> > Hi ,
> >> >
> >> > I have created a login id on 2 different databases DB_A & DB_B as the
> >> > owner
> >> >
> >> > from crystal report i can see the view of DB_A but not DB_B using the
> >> > same
> >> > login id
> >> >
> >> > Could anyone kindly advise ?
> >> >
> >> > tks & rdgs
> >>
> >>
> >>
>
>
Subscribe to:
Posts (Atom)