
select dbo.HelloWorld()

select * from sys.assembly_files

select * from sysobjects
 where type = 'U'

execute as user='tom'
create table tomstuff.tomtab (id int)
go
revert

select * from sys.tables

create login tom with password = 'StrongPW1'
create user tom for login tom
grant select on dbo.authors to tom
grant create table to tom

grant view definition on schema::dbo to tom

create schema tomstuff authorization tom

drop user tom

alter authorization on schema::tomstuff to dbo