You'll need a role in each database. You may want to create it in model so all of the new db's get it. Script out the CREATE ROLE and GRANT <PRIV> statements. It should be fairly easy to migrate them from one database to the next.
2004-02-12
I agree with Frank, use a single table with id, otherwise you will have to use dynamic sql.
2004-01-29
1 reads
Yep. He did do that. When I went and cleaned up the code I removed all those Select * to just the neccessary columns.He is also the guy that in order to get the number items in the returned recordset, did this:while not rs.eof
2004-01-16
Steve,"I'd script out the permissions from the old db" ....How would you do this?Bill
2004-01-16
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers