Re: Stored Procedure / GrantDbAccess

Thanks Roy!

Spelling! Sheesh!!! I looked at it several times and didn't catch it...

Next question: I'm really wanting to grant access to the DASL database for
any user with access to the DASLr2 database. When I specify:

declare login_curs cursor for select name from DASLr2..logins where name
<> 'sa'

and run the SP, I receive the error message: Invalid object name
'DASLr2..logins'.

I tried "DASLr2..logins", "DASLr2.dbo.logins", and still received the same
error. What's the magical syntactical combination I'm looking for?

Thanks again...
.

Quantcast