DBO but no DBO 
Author Message
 DBO but no DBO
We have a SQL server backend connected to a public IIS Web server.
Originally we did not give the anonymous IIS user the DBO role because we
just want it to be a database reader. Later on, for performance reason, we
started to move select statements into
stored procedures. For stored procedures to be invoked, the caller must be
DBO. So we have to let the anonymous IIS user have the DBO role. Is there
any way can we allow stored procedures to be invoked without granting DBO?

Thanks,
Nhom Nguyen



Sat, 29 May 2004 05:29:17 GMT
 DBO but no DBO

you do not have to assign dbo to a user just to allow the user to execute a
stored procedure.

grant EXECUTE on [storedprocname] to [user]

should be more than adequate for normal use.  it might be needed to grant
'select' on the based tables if you have dynamic query in your stored
procedures.

-oj


Quote:
> We have a SQL server backend connected to a public IIS Web server.
> Originally we did not give the anonymous IIS user the DBO role because we
> just want it to be a database reader. Later on, for performance reason, we
> started to move select statements into
> stored procedures. For stored procedures to be invoked, the caller must be
> DBO. So we have to let the anonymous IIS user have the DBO role. Is there
> any way can we allow stored procedures to be invoked without granting DBO?

> Thanks,
> Nhom Nguyen



Sat, 29 May 2004 05:40:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. dbo.sysalternates, dbo.sysconstraints, INFORMATION_SCHEMA etc

2. Copying data from databaseA.dbo.table1 to databaseB.dbo.table1

3. granting dbo so objects are owned by dbo

4. Avoid seeing dbo.sysalternates,dbo.sysconstraints, INFORMATION_SCHEMA_etc from MS Access Client

5. dbo vs. alias dbo

6. DBO account no longer DBO

7. URGENT! SELECT permission denied on object (owner = dbo) when connecting as dbo

8. Access2K stored procedure list with {dbo} and without

9. dbo

10. Table Names (dbo)

11. dbo added to file

12. Changing a user to dbo


 
Powered by phpBB® Forum Software