Re: OT : sql server roles help
actually, if in the query. I give the table owners name before the table. I can see it. So somehow the login doesnt know enough to look at the tables owner. Hmm. Anybody? On 5/25/05, DRE [EMAIL PROTECTED] wrote: Hi, I'm not that familiar with sql server but I've got a database that I can connect to. However, cf cant see a table. I know this has to do with roles and permissions and stuff like that but I just cant seem to get it right. Anybody got any tips? Thanks. -- DRE www.webmachineinc.com www.theanticool.com -- DRE www.webmachineinc.com www.theanticool.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT : sql server roles help
actually, if in the query. I give the table owners name before the table. I can see it. So somehow the login doesnt know enough to look at the tables owner. Hmm. Anybody? If the login is different from the actual table owner, you will have to specify the table owner within the table name reference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207689 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT : sql server roles help
Hmm, so how do I create a login thats the same as the table owner? I tried the login wizard and used the same name as the table owner and now have two users with the same name. Both seem to be the table owners but neither seems to be a login! I'm sure I'm close! Thanks for any help in advance. DRE On 5/25/05, Dave Watts [EMAIL PROTECTED] wrote: actually, if in the query. I give the table owners name before the table. I can see it. So somehow the login doesnt know enough to look at the tables owner. Hmm. Anybody? If the login is different from the actual table owner, you will have to specify the table owner within the table name reference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT : sql server roles help
Hmm, so how do I create a login thats the same as the table owner? I tried the login wizard and used the same name as the table owner and now have two users with the same name. Both seem to be the table owners but neither seems to be a login! I'm sure I'm close! Thanks for any help in advance. Logins are server-wide. Once you have a login, you can assign it to a user or role within a specific database. I've never used the create login wizard, so I can't help you there, but once you have a login you can go to the specific database within Enterprise Manager, go to Users, and assign the user to the login. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54